|
|
| Re: Undo Tablespace & omf [message #57508 is a reply to message #57476] |
Thu, 19 June 2003 11:03  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
undo tablespace is where oracle maintained undo (rollback) segments are stored. so if you use the feature (undo_management=auto) then you do not create rollback segments. oracle will create them and bring them online in your undo tablespace.
oracle managed files (omf) its a new way of creating the database files. you set some init.ora parameters (db_create_*) setting where you want to files to go. and then when you add a datafile or a redo log you dont need to specify the location (it uses parameters) or the name of the file. also when you drop the file, oracle automatically removes from the os.
(Oracle 9i Database Concepts Manual introduces both of these topics because they are new in 9i).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
