Re: probleming dropping a tablespace
Date: Mon, 3 Nov 2008 08:39:50 -0600
It may be that Oracle is still in the process of creating the tablespace. Wait for an hour or see and see what happens.
On Mon, Nov 3, 2008 at 8:30 AM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:
> 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?
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 03 2008 - 08:39:50 CST