Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

difference between oracle8i and oracle9i

Answer Posted / anjali

1) u have automatic undo management.

2)u have automatic segment space management

3)u got these locally managed tablespaces which is better
than the dictionary managed tabespaces as u can avoid
fragmentation with locally managed tablespaces.

4)u have a new dbms_metadata package to extract object
definitions from database.

5)multi table insert is possible with 9i

6)importanly u have this spfile in 9i.

7) also u have dynamic memory mangement facility with 9i.

8) u have tuning advisories with 9i.

9) u have multi block size parameter with 9i and many more
features like these

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to store only time; not date and time?

974


What are the differences between char and nchar in oracle?

1037


What is transport network substrate (tns) in oracle?

1003


What is bind variable in oracle 11g?

1009


How to rollback the current transaction in oracle?

1001


Can objects of the same schema reside in different tablespace?

1017


what is normalisation?what are its uses?

2223


What are the data types in oracle?

995


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1891


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1968


material view and view disadvantages?

1024


What is a package in oracle?

1048


What is the use of file param in imp command?

1132


How to write text literals in oracle?

1034


How to use in conditions in oracle?

1013