oracle9i企業(yè)版跟標(biāo)準(zhǔn)版的區(qū)別

1、Oracle9i企業(yè)版和標(biāo)準(zhǔn)版的區(qū)別功能，選件高 口用性(High Availability)Oracled 標(biāo)準(zhǔn)版C)raclc9/企業(yè)版?zhèn)渥?Jraclc Data Guard無右基本可讀待機(jī)數(shù)據(jù)庫readable standby database).仃快速啟劭可選恢更時(shí)間(Faststart selectable recovery time)無有在線索引構(gòu)建(Online index build)無有在線表里組，期定義(Online 1aMe rcorganization.rcdcfi nition無有在線索引合并(Online index coalesce)無有DDL中的全局索引維護(hù)1

2、 Global index indintcnanuc during DDL)仃有閃回查詢 I Flashback Query)有有沉寂數(shù)據(jù)庫Quiesce database)無有塊級(jí)介質(zhì)恢41 (Bk)ck4eveJ media rceo cry)無有增吊備份與恢復(fù)(Incremental backup and recovery)無有在線備份與恢復(fù)(Online backup and recovery)有有功能/選件Oracle9i 標(biāo)準(zhǔn)版(raclc9i 企業(yè)版箸注DBMS REPAIR 軟件包 (DBMSRLPAIR package)有有DBMS ME】 ADA 1A軟件包 (DBMSME

3、TADATA package)有有下拉列(Drop column)有有索引坦織表(Index-oTxanizcd table)有有替代觸發(fā)器(Instead-of triggcix)有有人型對(duì)軟支持(LOH) (lajyeobject support)有有本坨管理的表空間(Locally managed tablespaces)有有LpgMiner有多沖塊長度支持(Mult甲lc block size support)有有規(guī)劃穩(wěn)定性(Planstability)有反向主鍵索引 (Reverse key index)有臨時(shí)表(Tonpcraiy table)有有功的選件OrackOi 品械Ora

4、cle9/ 企業(yè)版番注Grade Real Application Clusters無有另外付費(fèi)選件Java本地編譯(Java native compilation)有有PL/SQL本均編譯(PLSQL native compilation)有自安全功能(Security)高級(jí)安全選件(Advanced Security Option 無有另外付費(fèi)選件安全標(biāo)簽:Oracle Label Security無有另外付費(fèi)選件加密工具包(Encrypttoolkit)有有虛擬個(gè)人數(shù)據(jù)庫Virtual Private Database)無ft粒化審計(jì)(Fine grained auditing)無有口令

5、管理(Passwoid imnagcment)有有代理驗(yàn)證(Proxy authentication)有有開發(fā)平臺(tái)(Dcvclopm6t Platform)Oradc Programmer有有另外付費(fèi)選件Java 支持(Java sqiport)有有SQU有有需要Oracle ProgrammerJDBC 雯動(dòng)器(JDBC dnvers)有有XML 支持(XML support)有W對(duì)望與可擴(kuò)展性(Objects and extensibility)有有PUSQL存儲(chǔ)進(jìn)程與觸發(fā)器 (PL/SQL stored procedures and 1 ris、i有有PL/SQL Senrr Pages

6、 (PSP)有有用戶定義聚類(Usepdefined aggregates)有有功能,選件Oracle理版Orucle9j 企收各注目事”匚(Autonomous transactions)有iSQLPlus有有可管理性O(shè)racle Enterpnse Manner有有Orade Change Management Pack無有另外付費(fèi)選件Oracle Diagnostics Pack無有另外付費(fèi)選件Grade 1 unin* Pack無有另外付費(fèi)選件Orade Management Pack forOracle Applications無有另外付費(fèi)選件Oracle Management Pa

7、ck torSAPK3無有另外付費(fèi)選件自動(dòng)恢空管理(Automatic undo management)有有自優(yōu)化內(nèi)存管理(Self-tuning memory management)有有SK務(wù)轉(zhuǎn)管理的箸份與恢復(fù) (Server managed backup and recAivery)有有快史管理群(Recovery Manager 有有Lq?ato Storage Manager有有雙工備份套件(Duplexed backup sets)無數(shù)據(jù)庫資源管理(DatabaseResource Manager 無有Oracle Managed Filesft-有可恢Si空間分fit? (Resu

8、m able space allocs ion)有有*用索引識(shí)別(Unused indoc identitlcation)有有VLDB、數(shù)據(jù)建倉.商務(wù)智能(VLDH, DgBiutne bitclli0enoe)數(shù)據(jù)分區(qū)選件(Oracle Partitioning)無有另外付費(fèi)選件Oracle OLAP無有另外付費(fèi)選件數(shù)據(jù)挖掘(Oracle Data Mininiz )無有另外付費(fèi)選件功的選件Oracle / .淘1()raclc9i 企業(yè)版番注位圖化索引和位圖化聯(lián)合索 引(Bitmapped index and bitmapped join index)無有降序索引(Descending i

9、ndex)ft有基于功能的索弓I (Punctio based index)有有自動(dòng)并仃查前度(Automated parallel query degree)無有并行分析(Parallel analyze)無有需要Oracle Partitioning并行位圖星狀查詢優(yōu)化 (Parallel bitmap star query optimization)無有并行 DML (Parallel DMLNYRequires Oracle)無有需要Oracle Partitioning并行索引構(gòu)建(Parallel index build)杓需要Oracle Partitioning并行索弓1掃描(

10、Parallel index scans)無有并行加載(Parallel load)有有并行查詢(Parallel query)無有星狀查詢優(yōu)化(Star query optimization)有有樣本打描(Sample scan)有有摘要管理(Summary maTugement)無有長運(yùn)算論視器(Long operations monitor)有有Direct Path Load API白有導(dǎo)出可移動(dòng)表空間(Export transpartab Ie tablespace)無有導(dǎo)人可移動(dòng)表空間(Import transpiirtablc tablespace)有有外部數(shù)描表(Extenul

11、 tables)白有MERGE有有多表插入(Multi-table insert)有有功能，選件Oracle。？ 標(biāo)準(zhǔn)版Oracle% 企業(yè)版著注集成(Integration)高級(jí)隊(duì)列(Advanced Queudng )有有Messaging Gateway to 1BMMQSehes(與IBM MQScncs之間的 消息傳遞網(wǎng)關(guān))無右基本史制(Basic Replication )w有可更新的物化視圖 站點(diǎn)(Updatable material ized view site)高級(jí)復(fù)制(Advanced Replication)無有多主站復(fù)制(Multi. master rephcation)分布式查詢(Distributed queries)有有分布式事務(wù)處理(Distributed transactions)有有異構(gòu)服務(wù)(Heterogenex)us Services)有有網(wǎng)絡(luò)(Networking)連接池(Connection pooling)有有tTrade Connection Manager無有(rade Names有有Oracle Net S