The following features are desupported in 10g: Support for regular expressions in SQL and PL/SQL.New asmcmd utility for managing ASM storage.The CONNECT ROLE can now only connect (CREATE privs removed).NID utility has been introduced to change the database name and/or id.Datapump - faster data movement with expdp and impdp.

Support for bigfile tablespaces that are up to 8 Exabytes in size.

New database scheduler - DBMS_SCHEDULER.

Ability to transport tablespaces across machine types (E.g Windows to Unix).

Ability to UNDROP a table using a recycle bin.

Flashback operations available on row, transaction, table or database level.

Automatic Database Diagnostic Monitor ( ADDM).

Performance and scalability improvements.

Manageability improvements (self-tuning features).

Grid computing - an extension of the clustering feature ( Real Application Clusters).

The following new features were introduced with Oracle 10g: Premier Support Ends: 31-Jul- 2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul- 2011)Įxtended Support Ends: 31-Jul- 2013 Features introduced

Latest patch-set: 10.2.0.5 (the terminal patch set for this release) In July 2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. In 2003, Oracle Corporation released Oracle Database 10g Release 1 (10gR1).Įxtended Support Ends: 01-Jan- 2012 Oracle 10g Release 2 (10.2.0)

Difference between oracle 10g and 11g