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 oracle 8i and oracle 9i

Answer Posted / priya tyagi

1.In Oracle 8i defualt table space is dictionary managed
where as in 9i it is locally managed.
2.oracle 8i doesn't provide auto undo segment managment
where as 9i provides auto undo segment managment .
3.in 8i multi table insert is not possible where as it is
present in 9i.
4.in 8i Dynamic memory managment facility is not present
which is present in oracle 9i.

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind variable in pl sql?

1105


What is field delimiter?

1112


Can we use commit inside a trigger?

1147


Which is faster subquery or join?

1270


What are the rules to be applied to nulls whilst doing comparisons?

1369


Why query optimization is needed?

973


What has stored procedures in sql and how we can use it?

1126


what are integrity rules?

1092


What does pl sql stand for?

1156


Can we group by two columns in sql?

1046


what are the difference between clustered and a non-clustered index? : Sql dba

1085


Explain the working of foreign key?

1136


What is the most restrictive isolation level? : Transact sql

1126


What are the sql aggregate functions?

1184


What is sql scripting?

1194