Differences between the three Oracle 10g versions

Standard one, standard, and enterprise are commonly used in Oracle 10 Gb operations. Do you want to know the specific differences between these three versions, the following article introduces the three frequently used versions of Oracle 10g ..

Reference

Oracle10g is divided into four versions:

1. Oracle Database Standard Edition One, the most basic commercial version, including basic Database functions.

2. Oracle Database Standard Edition, Standard Edition, including the features and RAC of the above version. RAC is included only in the 10 Gb Standard Edition.

3. Although Oracle Database Enterprise Edition and Enterprise Edition are the most powerful versions, not all of the features we commonly use are in this version, and many things still require additional charges, it will be mentioned later.

4. Oracle Database Personal Edition, Personal Edition, includes all functions of the Enterprise Edition except RAC, but note that only the Personal Edition is available on Windows platforms.

Next let's take a look at the features that are not supported in Standard Edition One and Standard Edition, but some of them are common or commonly used.) Note, in addition to RAC, these features are still included in the Personal Edition.

1. Oracle Data Guard, not supported. Customers who want high availability cannot select the Standard Edition)

2. Some Online operations, such as Online index maintenance and Online table redefinition, are not supported.

3. Backup and recovery operations are limited, such as Block-level media recovery), Parallel backup and recovery of Parallel backup and recovery), multiple backup Duplexed backup sets) and so on.

4. The Flashback function is not supported by Flashback Table, Flashback Database, and Flashback Transaction Query in the Standard Edition.

5. VPDVirtual Private Database) not supported

6. FGAFine-grained auditing) not supported

7. Partitions are not supported either.

8. Data compression, such as table compression and partition compression are not supported

9. Bitmapped index and bitmapped join index are not supported. If the data warehouse system is used, the standard version cannot be selected)

10. Export transportable tablespace, note that the Import is not supported here), but the import transportable tablespace in Oracle 10g, including cross-platform Import, is supported, that is, if you select the Standard Edition, it is difficult to simply transfer the database to other platforms.

11. Some Parallel operations are not supported, including Parallel query, Parallel DML, Parallel index build, Parallel Data Pump export and import.

12. Streams is not supported, and a high availability feasible solution is missing.

13. The multi-master mode of Advanced Replication is not supported, and a high availability solution is missing. Of course, the Replication solution of the materialized view is still supported.

14. Connection Manager is not supported.

The Standard Edition supports RAC in Oracle 10 Gb, But oracle has restrictions. To use RAC in the Standard Edition, you can only use Oracle Clusterware and do not support any other third-party cluster software ), at the same time, you must use ASM to store and manage data files. other third-party volume management and file systems are not supported ). If you want to install another database as RMAN repository or OEM Grid Control repository, you do not need to pay additional fees.