| Undo Tablespaces [message #62699] |
Tue, 10 August 2004 03:16  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi,
My database is running in NoArchivelog mode and file pertaining to Undo tablespaces is damaged. I gave the option
"alter database datafile 'undo datafile path' offline drop;"
with this i was able to OPEN the database.Then i created a new UNDO tablespace.
My ques is since db was running without UNDO tbs(as i make it offline drop) so how can i make sure that after creating the new UNDO tbs, the database is using the new UNDO tbs.
waiting for a reply
Vivek
|
|
|
|
|
|
| Re: Undo Tablespaces [message #62703 is a reply to message #62699] |
Tue, 10 August 2004 04:12  |
Gorjan Todorovski
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
If you have ora 9i or 10g and automatic undo management is set. You
can:
SYSTEM@hello > alter system set undo_tablespace=UNDOTBS1;
This will ensure usage of UNDOTBS1 tablespace.
If you have 8i, create rollback segment(s) in that tablespace, and make
sure that they are online.
Only SYS/SYSTEM users can use the SYSTEM rollback segment so if
there is no avaible rollback segment there will an error of the type that
you can not user system rollback segment.
-----
www.oracleclinic.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
