probleming dropping a tablespace

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Mon, 3 Nov 2008 09:30:51 -0500
Message-ID: <f30139790811030630q69a9fbcn8cbc204c2c2016@mail.gmail.com>


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?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 03 2008 - 08:30:51 CST

Original text of this message