Deleted dbf file on O/S still have tablespace 1

[jestrada101]

How can I drop tablespace on Oracle if the databafile has been deleted?

Thanks!
JE

 

[SantaMufasa]

J,

I don't have a throw-away database to confirm my memory of the method, but as I recall (under your circumstances), you do the following:

1) shutdown abort
2) startup mount
3) alter database datafile '<datafile name>' offline drop;
4) drop tablespace <tablespace name>;
5) alter database open;

...or something like that. (I'm on vacation and don't have my manuals handy.) Try that and post the results. We can offer other suggestions once you try this.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[jestrada101]

Thanks Mufasa. That worked perfectly!