Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Unable to recover datafile - urgent
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-lReceived on Wed Sep 22 2004 - 11:40:09 CDT
![]() |
![]() |