用法和企业版基本一致。express版本不包含的特性有
Options and Major Features Not Included:The following options and major features are not included with Oracle Database XE:Development PlatformOracle Precompilers (Pro*C/C++, Pro*Cobol)
SQLJ
High Availability:Automatic Block Repair
Block change tracking for fast incremental backup
Block-level media recovery
Duplexed backup sets
Fast-start fault recovery
Flashback Database
Flashback Data Archive
Flashback Table
Flashback Transaction
Lost Write Protection
Online index rebuild
Online index-organized table organization
Online table redefinition
Oracle Active Data Guard
Oracle Data Guard-Redo Apply
Oracle Data Guard-Snapshot Standby
Oracle Data Guard-SQL Apply
Oracle Fail Safe
Oracle RAC One Node
Parallel backup and recovery
Rolling Upgrades-Patch Set, Database, and Operating System
Tablespace point-in-time recovery
Trial recovery
Unused block compression in backups
Oracle Total Recall
ScalabilityAutomatic Workload Management
Oracle Real Application Clusters
SecurityAdvanced Security Option
Fine-grained auditing
Oracle Database Vault
Oracle Label Security
Oracle Virtual Private Database
Secure External Password Store
SecureFiles Encryption
PerformanceClient Side Query Cache
Database Smart Flash Cache
In-Memory Database Cache
PL/SQL Function Result Cache
Query Results Cache
Server Flash Cache
Support for Oracle Exadata Storage Server Software
Xstream
ManageabilityDatabase Resource Manager
Deferred segment creation
Instance Caging
Oracle Change Management Pack
Oracle Configuration Management Pack
Oracle Diagnostic Pack
Oracle Real Application Testing
Oracle Provisioning and Patch Automation Pack
Oracle Tuning Pack
SQL Plan Management
VLDB, Data Warehousing, Business IntelligenceAsynchronous Change Data Capture
Basic Table Compression
Bitmapped index, bitmapped join index, and bitmap plan conversions
Deferred Segment Creation
In-memory Parallel Execution
Oracle Advanced Compression
Oracle Data Mining
Oracle Data Profiling and Quality
Oracle Data Watch and Repair Connector
Oracle OLAP
Oracle Partitioning
Parallel Data Pump Export/Import
Parallel index build/scans
Parallel query/DML
Parallel Statement Queuing
Parallel statistics gathering
Summary management-Materialized View Query Rewrite
Transportable tablespaces, including cross-platform
IntegrationAdvanced Replication
Gateway for DRDA
Gateway for Informix
Gateway for SQL Server
Gateway for Sybase
Gateway for Teradata
Messaging Gateway
Oracle Streams
Content ManagementOracle Multimedia
Semantic Technologies (RDF/OWL)
Spatial and Location DataMultimaster replication of SDO_GEOMETRY objects
Oracle Spatial
Parallel spatial index builds
Partitioned spatial indexes
NetworkingInfiniband Support
Oracle Connection Manager
Options and Major Features Not Included:The following options and major features are not included with Oracle Database XE:Development PlatformOracle Precompilers (Pro*C/C++, Pro*Cobol)
SQLJ
High Availability:Automatic Block Repair
Block change tracking for fast incremental backup
Block-level media recovery
Duplexed backup sets
Fast-start fault recovery
Flashback Database
Flashback Data Archive
Flashback Table
Flashback Transaction
Lost Write Protection
Online index rebuild
Online index-organized table organization
Online table redefinition
Oracle Active Data Guard
Oracle Data Guard-Redo Apply
Oracle Data Guard-Snapshot Standby
Oracle Data Guard-SQL Apply
Oracle Fail Safe
Oracle RAC One Node
Parallel backup and recovery
Rolling Upgrades-Patch Set, Database, and Operating System
Tablespace point-in-time recovery
Trial recovery
Unused block compression in backups
Oracle Total Recall
ScalabilityAutomatic Workload Management
Oracle Real Application Clusters
SecurityAdvanced Security Option
Fine-grained auditing
Oracle Database Vault
Oracle Label Security
Oracle Virtual Private Database
Secure External Password Store
SecureFiles Encryption
PerformanceClient Side Query Cache
Database Smart Flash Cache
In-Memory Database Cache
PL/SQL Function Result Cache
Query Results Cache
Server Flash Cache
Support for Oracle Exadata Storage Server Software
Xstream
ManageabilityDatabase Resource Manager
Deferred segment creation
Instance Caging
Oracle Change Management Pack
Oracle Configuration Management Pack
Oracle Diagnostic Pack
Oracle Real Application Testing
Oracle Provisioning and Patch Automation Pack
Oracle Tuning Pack
SQL Plan Management
VLDB, Data Warehousing, Business IntelligenceAsynchronous Change Data Capture
Basic Table Compression
Bitmapped index, bitmapped join index, and bitmap plan conversions
Deferred Segment Creation
In-memory Parallel Execution
Oracle Advanced Compression
Oracle Data Mining
Oracle Data Profiling and Quality
Oracle Data Watch and Repair Connector
Oracle OLAP
Oracle Partitioning
Parallel Data Pump Export/Import
Parallel index build/scans
Parallel query/DML
Parallel Statement Queuing
Parallel statistics gathering
Summary management-Materialized View Query Rewrite
Transportable tablespaces, including cross-platform
IntegrationAdvanced Replication
Gateway for DRDA
Gateway for Informix
Gateway for SQL Server
Gateway for Sybase
Gateway for Teradata
Messaging Gateway
Oracle Streams
Content ManagementOracle Multimedia
Semantic Technologies (RDF/OWL)
Spatial and Location DataMultimaster replication of SDO_GEOMETRY objects
Oracle Spatial
Parallel spatial index builds
Partitioned spatial indexes
NetworkingInfiniband Support
Oracle Connection Manager
解决方案 »
- 目前表空间磁盘管理采用什么方式
- vc6开发的程序 64位的oracle10.2客户端 连接 64位AIX5.3机器上的oracle10.2的数据库服务器 失败
- 请教如何连接Novell 4.11服务器上的Oracle 7.0 NetWork数据库?
- 急:怎样用SQL查出TEMP表空间的使用率?
- 关于建表外间的问题
- 为何不能创建表空间?
- ********ORACLE 8 的奇怪问题,在线等待,解决马上给分!!**********
- 求delphi7或者xe5链接oracle的方法
- oracle 异地数据库同步。
- 我想新建一个A表,但是这个A表的列名是 我查询B表的结果集,请问该如何实现?存储过程?
- 表数据交换
- select to_char(visit_date,'yyyyMMdd') || to_char(visit_no,'00000')
顺便想了解下.如何实现用java代码.开启和关闭oracle数据库