Re: Tablespace created, file destroyed - HELP!

In article <2u6iu4INN6f8_at_anaconda.cis.ohio-state.edu>, mascari_at_cis.ohio-state.edu (michael v mascari) writes:
> then ... I deleted
> the 10M datafile for the data tablespace, the 5M file for the tempspace,
> and the 3M file for the index tablespace. After a while, Oracle compained
> about the fact it couldn't access those tablespaces (because I never
> dropped the tablespace from the database), and then it quit.
> Now I can't start Oracle at all, even to drop the tablespace
> because the files (that I don't want) aren't there. I tried making
> up some junk files, but Oracle still wouldn't mount the database
> because the junk files failed verification. Is there any way (besides
> restoring from backup) or any file that I can edit, that I can convince
> Oracle that those tablespaces aren't there?
>

WARNING ****** 	THE FOLLOWING COMMANDS WILL DESTROY ALL DATA IN THE
		TABLESPACES YOU NAME --- DO THIS ONLY IF YOU 
		ARE SURE YOU WANT TO DESTROY THIS DATA!!!!!

Go into sqldba and

        startup mount

then

	alter database datafile 'full_file_name_here' offline;
	alter database datafile 'next_file_name_here' offline;
	...

Repeat until you have taken all the datafiles that you deleted offline. (Only take the datafiles that are part of the corrupted tablespaces offline,  all other files should be left online);

Now you should be able to

        alter database open;
and

	drop tablespace bad_tablespace_name1 including contents;
	drop tablespace bad_tablespace_name2 including contents;
	...

Again, repeat until all the corrupted tablespaces are dropped.

You should then shutdown and startup you database to make sure everything is okay.

Good Luck!

Sonja Kattner
cimu05.att.com Received on Tue Jun 21 1994 - 23:20:06 CEST