Re: deleting tablespaces without dropping them first

"bas" <bas_at_NOSPAM.profeten.nl> wrote in message news:<3fe6ae7a$0$7860$3b62cedd_at_news.wanadoo.nl>...
> As you can see from the subject, I made a screw-up. I've deleted tablespaces
> (the actual files) without dropping them first. I cannot find a way to tell
> Oracle now that the tablespaces are gone and should be dropped.
> Does anybody here know how to do just that?
>
> Kind regards,
>
> Bas

i believe the process is.

1. shutodwn abort
2. startup nomount. stay as sysdba user.
3. drop the tablespace.

someone correct me if im wrong. I always have to look this stuff up. Received on Mon Dec 22 2003 - 09:55:02 CST