Hi,

I'm running Oracle 8.1.5 on Linux.

I created a new tablespace today:

sqlplus> ALTER TABLESPACE INDEX001 add datafile '/u02/oradata/index00100.dbf' SIZE 2000K


I then realized I needed 2000M, not 2000K. By mistake, I deleted the file /u02/oradata/index00100.dbf from a linux shell. I did not 'drop' the tablespace from sqlplus first.

Now, the DB won't start up, so I can't get into sqlplus to drop the tablespace. How do I fix this??

I am not a DBA, but have been left with an Oracle instance to support, with no DBAs on staff or any Oracle support.

Thanks in advance for any help,

-Joseph DeFanti