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

Home -> Community -> Mailing Lists -> Oracle-L -> Unable to recover datafile - urgent

Unable to recover datafile - urgent

From: Manjula Krishnan <oradba.la_at_gmail.com>
Date: Wed, 22 Sep 2004 11:44:01 -0500
Message-ID: <9c92486f0409220944136b699b@mail.gmail.com>


There is one datafile which shows status of "RECOVER". This datafile was created in the wrong tablespace and immediately offlined. For some reason a batch job is trying to read from this datafile, and it comes up with ORA-376 and ORA-1110. I am not able to recover this datafile because it needs an old archive log and that archive log does not exist on the system.

How can I find out if this datafile has any objects in it? (I am pretty sure it does not). And if it does not I would like to remove this datafile.

Is exporting tablespace/dropping tablespace and reimporting my only option?

Thanks,

Manjula

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 22 2004 - 11:40:09 CDT

Original text of this message

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