Re: probleming dropping a tablespace

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: oracledbaquestions@xxxxxxxxx
  • 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@xxxxxxxxx>wrote:

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



-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: