Re: probleming dropping a tablespace

From: Andrew Kerber <>
Date: Mon, 3 Nov 2008 08:39:50 -0600
Message-ID: <>

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 <>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.'

Received on Mon Nov 03 2008 - 08:39:50 CST

Original text of this message