Re: probleming dropping a tablespace
Date: Mon, 03 Nov 2008 18:20:27 +0100
Dba DBA schrieb:
> 10.2.0.1 <http://10.2.0.1>
> windows server 2003
> I was creating a tablespace today and lost my VPN connection. I log back
> in. No tablespace, but the datafile is. I go to remove the datafile and
> it says that oracle is using it.
> I checked the data dictionary before hand and the tablespace does not
> appear in dba_tablespaces.
> if i shutdown oracle and simply delete the datafile at the OS, is this
> safe? Should I be able to restart oracle without a problem?
don't delete it, just rename it. if you have problems after bouncing the instance, you can rename it back.
-apReceived on Mon Nov 03 2008 - 11:20:27 CST