Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems with lost datafile
Find out all the index segments in the tablespace. Drop the tablespace .
Recreate it and then create all the indexes one by one.
MUrali
"Edvinas" <Edvinas_at_takas.lt> wrote in message
news:367c7fb8.0201230254.197bc43f_at_posting.google.com...
> hi all,
>
> i have very interesnisg problem.
> One oracle database file was lost,
> it was a datafile of indexes tablespace.
> i wantes to startup database, so i droped it:
> alter database datafile 'xxx' ofline drop;
> then: alter database open;
> all is ok. database online... but of course indexes are not good. i
> tried to drop tablespace, but i could not.
> i tried to: alter database create datafile 'xxx';
> it creates the file, but what next ?
> what i must do, to rebuild all these bad indexes in new datafile ?
> i have not any ARC.
Received on Wed Jan 23 2002 - 07:31:10 CST