-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|