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

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087


Why do you use stored procedures and state some of its disadvantages?

1028


What is a nested table and how is it different from a normal table?

1051


Explain about integrity constraint?

1122


how the indexes are stored in the Oracle Database?

2271


Can a formula column referred to columns in higher group ?

2506


What are set operators?

1082


What is the use of file param in imp command?

1165


What is index-organized table in Oracle?

1069


What language does oracle use?

1100


What are the ansi data types supported in oracle?

947


What is the disadvantage of User defind function?

2293


List out the difference between commit, rollback, and savepoint?

1031


Explain the use of parfile option in exp command.

1069


Give the different types of rollback segments.

1031