RE: Datafile Recovery!!
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'sfaroult@xxxxxxxxxxxx'" <sfaroult@xxxxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Feb 2005 12:05:36 -0500
Yes, Basically since an IOT is a table stored within the PK index we
allocate IOT's to table tablespaces rather than index tablespaces. Admane,
you will have to drop the table to put your plan into action. This means
you will need to be able to go back to an export file for the table or have
another means of recreating it. Going back to an export could result in
data loss if any DML has been applied to the table since the export.
Alternately you will need to restore the datafile from the last backup and
run forward recovery assuming the database is in archivelogmode.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephane Faroult
Sent: Monday, February 14, 2005 11:21 AM
To: Narendra.Admane@xxxxxxxxxxxxxxx
Cc: ORACLE-L
Subject: 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
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
