| Difference between Oracle 8 and 9i [message #73757] |
Thu, 01 July 2004 12:30  |
subbu
Messages: 27
Registered: July 2002
|
Junior Member |
|
|
Could U anyone tell, what are the differences/upgrades from Oracle 8 to Oracle 9. I searched through internet, I got only meager informations.
I will appreciate your reply
Thanks,
Subbu
|
|
|
|
| Re: Difference between Oracle 8 and 9i [message #73760 is a reply to message #73757] |
Fri, 02 July 2004 07:28  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
For example, i love this:
RESUMABLE SESSION, you can alter a session to be resumable, so if you are creating huge indexes, or doing some large inserts and you run out of space, the session got suspended until you free space and automatically resume execution, so, there is no rollback and start over!.
You have also Workspace Manager, thi is table versioning feature. It means you can have one table and some virtual copies so users can access one of them and do their jobs independently of other users doing their stuff on the same table. Each user can see their only modifications. You can merge all those virtual tables into the master any time. This is a very good new feature.
You can have UNDO tablespace instead of rollback segments. This id good so you can forget about rollback segments maintenance.
Hope this helps.
Best regards.
www.otools.com.ar
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
