Re: probleming dropping a tablespace

From: David Ballester <>
Date: Mon, 3 Nov 2008 18:28:54 +0100
Message-ID: <>

2008/11/3 Dba DBA <>

> 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?

First of all you must take a look at the alert log some seconds before your disconnection to see what was going.

In the future, use some type of terminal service or ssh to minimize this situations.


Received on Mon Nov 03 2008 - 11:28:54 CST

Original text of this message