How to delete Tablespace when datafile is missing ?
From: Kohc <Kohc_at_cgs.edu>
Date: 1995/04/15
Message-ID: <3moj69$65l_at_jaws.cs.hmc.edu>#1/1
Date: 1995/04/15
Message-ID: <3moj69$65l_at_jaws.cs.hmc.edu>#1/1
Hi Netters,
Forgive me for asking a newbie question as I am indeed
new.
I have created a tablespace (A) with a datafile (DF).
However I make a mistake by deleting the DF. Now
whenever I try to drop A in SQLPLUS, I get an error
indicating that the Datafile is not found.
How can I drop my tablespace now ? You help will be
very much appreciated.