Re: How to workaroung ORA-01122 error on ALTER DATABASE OPEN?

Hello, robert!
You wrote on Thu, 17 Jan 2002 21:47:34 -0000:

 rm> If you can do alter database backup control file to trace;
 rm> now go to .../udump and edit the trace file and delete the line with
 rm> the tablespace.
 rm> Now connect internal and execute the trace file.

You could do it without recreation of controlfile i guess...

startup mount
alter database datafile 'xxx' offline drop; alter database open;
drop tablespace XX including contents;

You could get info about datafiles fron v$datafile after startup mount... Did i miss smth?

• Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198