Re: Oooh, I think I did a bad thing....

Hey Everybody !!

Whew! I got Oracle up and running again. Here are the exact steps that I followed:

How To Fix Oracle When A (Tablespace) Datafile has been deleted:

1. Log into UNIX as the Oracle administrator
2. Start up SQL*DBA
3. connect internal
4. startup nomount
5. alter database mount;
6. Type in the following for each datafile that is gone: alter database datafile 'full path to datafile' offline drop;
7. alter database open;
8. Type in the following for each datafile that is gone: drop tablespace NAME_OF_TABLESPACE including contents;
9. shutdown
10. Exit SQL*DBA
11. Restart SQL*DBA
12. connect internal
13. startup

NOTE: This assumes that it is okay to sacrifice the data in the deleted datafiles.

Thanks again for the help.

Eric Kristoff
kristoff_at_baseware.com Received on Mon Jul 17 1995 - 00:00:00 CEST