Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> problems with lost datafile...
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 - 03:55:03 CST