Hi to All,

I'm just a humble Web developer who has the responsibility of managing the Oracle 8i DB that our Web sites use to do their thing.
I've run into a problem with the local 8i I'm running on W2000 as a development DB.

I mistakenly created a new database file in the INDX tablespace when it should have been placed in the SYSTEM tablespace.
Being unable to delete this DBF, I tried renaming it using:

alter tablespace indx rename datafile 'e:\oraclehome\ ... \system02.dbf' to 'e:\oradev\...\system02.dbf'

Afterwards, when attempting to take DB out of archivelog mode I got the error:

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: E:\.......\SYSTEM02.DBF

And now, when attempting an INSERT, I get the error:

ORA-00376: file 8 cannot be read at this time
ORA-01110: data file 8: 'E:\ORADEV\ ... \SYSTEM02.DBF'

Is there a way to delete this DBF and remove it from my life forever??

If not, can I simply DROP the tablespace INDX, recreate it, and then recreate all of the original indexes that were within it. This is a development DB, not production and there are not all that many tables in it so recreating the indexes would not be that big a deal for me.



Jack Gambardella
Web Master
Barron's Educational Series, Inc.
250 Wireless Blvd.
Hauppauge, NY 11788
Phone: 1-800-645-3476 ext. 375
Fax: (631) 434 3723
email: [Email address protected]




Oracle LazyDBA home page