Re: Datafile Recovery!!
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: Narendra.Admane@xxxxxxxxxxxxxxx
- Date: Mon, 14 Feb 2005 17:20:57 +0100
Narendra,
The IOT primary key index IS the table.
HTH
SF
Admane, Narendra wrote:
>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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
