Hello, everybody:
Oracle 8.1.7 on Sun2.6
Trying to create an additional datafile for tablespace xyz I screwed up.
Now xyz tablespace is offline; I deleted the 2nd (just created) datafile
using OS. Then I recreated this datafile (0 size) using UNIX touch
command.
I could not put xyz tablespace back online. Trying to fix this, I screwed
up even further.
I ran: alter database backup controlfile to trace. Then I edited trace
(deleted lines that put xyz offline and line related to just created 2nd
datafile). Then I ran script to recreate controlfile having db in mount
mode. After this I cannot even open database, but still I can mount it.
Now I just want to drop the tablespace involved (xyz) and be able to open
the database at least.
No backups exist; noarchivelog mode. I only saved controlfiles and
exported system.dbf before applying script to recreate controlfiles.
Please advise.
Thank you very much.
Joseph
Received on Sun Apr 29 2001 - 13:11:11 CDT
