Datafile Recovery!!

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