Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> tablespace deleted..............pl help me

tablespace deleted..............pl help me

From: arun <arun_maurya_at_hotmail.com>
Date: 24 Jan 2002 02:19:00 -0800
Message-ID: <a2d6b025.0201240219.17dfa651@posting.google.com>


I am running Oracle 8.0.5 on Solaris.
I have a database with a number of tablespaces. In one tablespace which has just two indexes in it, I dropped the indexes, forgot to drop the tablespace, then did a (Unix) rm to remove the
file that the tablespace was created with. Now, when I try to do a dbstart, I get errors ORA-01157: cannot identify data file 23 - data not found ORA-01110: data file 23: (path to the file I deleted)

and I cannot get into sqlplus -

ORA-01033: ORACLE intialization or shutdown in progress

I can't restore the file from backup because I just created the tablespace today, and the backup job runs tonight. How do I undo my mess?

looking for your helping hands.................
Received on Thu Jan 24 2002 - 04:19:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US