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
What is a cursor in oracle?
What are the parameters that we can pass through a stored procedure?
How to shutdown your 10g xe server from command line?
How do I reset a sequence in oracle?
What is flashback in Oracle?
What is the difference between substr and instr?
What are the ways tablespaces can be managed and how do they differ?
How to change program global area (pga) in oracle?
How to do paging with oracle?
How to create a server parameter file?
types of indexes and the rationale behind choosing a particular index for a situation.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is an oracle function?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
When system tablespace is created?