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