Home » RDBMS Server » Server Administration » UNDO tbs related issues
UNDO tbs related issues [message #62655] Fri, 06 August 2004 03:26
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

Report message to a moderator

Previous Topic: jre.exe has created error for me
Next Topic: ORA-03114 coming randomly while updating the data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 10:26:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.