Datafile Recovery!!
- From: "Admane, Narendra" <Narendra.Admane@xxxxxxxxxxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Feb 2005 16:10:26 -0000
Hello,
Version - 9=2E2=2E0=2E4
Os - solaris 8=0D
I lost one datafile for database, fortunately that datafile was the part of
index tablespace so I decided to -
1=2E drop all the indexes, drop tablespace, recreate tablespace and create
those index again=2E I got create index statements using dbms_metadata
package=2E
Unfortunately that tablespace contains the Primary key indexes from IOT
table=2E And when I tried to drop/rebuild the indexes, I got the errors
related to IOTs and LOB's=2E
Is there anyway to come over this situation?? Other wise I need to recover
the database from backup=2E=0D
Regards,
Narendra
This message contains information that may be privileged or confidential=
and is the property of the Capgemini Group=2E It is intended only for the=
person to whom it is addressed=2E If you are not the intended recipient, =
you are not authorized to read, print, retain, copy, disseminate, =
distribute, or use this message or any part thereof=2E If you receive this=
message in error, please notify the sender immediately and delete all =
copies of this message=2E
--
//www.freelists.org/webpage/oracle-l
Other related posts:
