Re: probleming dropping a tablespace

2008/11/3 Dba DBA <oracledbaquestions_at_gmail.com>

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

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.

D.

--
http://www.freelists.org/webpage/oracle-l