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
