What are the extra features available in Oracle 9i as compared to oracle 8i

Showing Answers 1 - 5 of 5 Answers

opbang

  • Sep 22nd, 2006
 

In comparison with Oracle 8i, 9i is have lot many new features.  important is

 

Dynamic database parameters

Data Guard

Log Miner

Enhanced RMAN

Enhanced for Data Warehousing

Real Application Cluster

Zero Data Loss Log Transport

Granular Control over resources

Three Tier Security

Enhanced Java Support

Enhanced Data management

 

and many more

 

 

Oracle9i Database new features are in the categories listed below.

 

Availability

Scalability

Performance

Security

Manageability

Development Platform for E-Business Applications

Windows Integration

Internet Content Management

E-Business Integration

Packaged Applications

Business Intelligence

 

 

 

  Was this answer useful?  Yes

Divya

  • Sep 27th, 2006
 

Thanks OM Prakash for ur kind help...

  Was this answer useful?  Yes

sree

  • Oct 5th, 2006
 

date  functions.

generic functions

  Was this answer useful?  Yes

manoj k jena

  • Oct 16th, 2006
 

Hi,

       plz send me the answer.

  Was this answer useful?  Yes

New Features in 9i are1. Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table rebuild7. Bitmap Join Index8. Renaming of Columns and constraints9. Primary Key,Unique key and Referential keys can be created on a View10. Named index can be created on Key Columns. Ie. we can create a index on primary key column 11. Optimizer hint First_rows is now extented with First_rows(n)12. Pl/sql tables are now named as Associative array and now can be indexed by string.13. Flashback Query14. For update statement is provided with a new option Wait.15. Index Monitoring16. Index Skip Scanning.Hope this helps

  Was this answer useful?  Yes

New Features in 9i are 1.Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table rebuild7. Bitmap Join Index8. Renaming of Columns and constraints9. Primary Key,Unique key and Referential keys can be created on a View10. Named index can be created on Key Columns. Ie. we can create a index on primary key column 11. Optimizer hint First_rows is now extented with First_rows(n)12. Pl/sql tables are now named as Associative array and now can be indexed by string.13. Flashback Query14. For update statement is provided with a new option Wait.15. Index Monitoring16. Index Skip Scanning.Hope this helps

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions