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

Can we save images in a database and if yes, how?

1108


Can we create database in oracle using command line ?

1127


What is a parameter file in oracle?

1185


What is oracle in java?

1008


What is a trace file and how is it created in oracle?

1135


How to use in conditions in oracle?

1103


Explain the use of record length option in exp command.

1113


What are the tools for Oracle ?

1105


How to check your oracle database 10g xe installation?

1041


What is the order of defining local variables and sub procedures/functions?

1111


What is oracle database client?

1077


How to define a variable of a specific record type?

1112


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1784


What are the various types of snapshots ?

1082


How to check database size in Oracle?

1250