probleming dropping a tablespace

From: Dba DBA <>
Date: Mon, 3 Nov 2008 09:30:51 -0500
Message-ID: <>
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?

Received on Mon Nov 03 2008 - 08:30:51 CST

Original text of this message