Re: probleming dropping a tablespace
- From: Andreas Piesk <a.piesk@xxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- 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.
-ap
--
//www.freelists.org/webpage/oracle-l
Other related posts:
