Re: Datafile Recovery!!

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
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l