Thanks Maggi, that's exactly what I did originally but afterwards, viewing my tablesapces through DBA Studio, the datafile (in its new directory) was still showing in the INDX tablespace and when attempting to take the DB out of archivelog mode I got the error:

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: e:\oradev\oradata_archive\system02.dbf

So I reversed the process, bringing the file BACk into the original \ORADATA\ directory and deleting it from \oradata_archive\ ....

Now I just tried to rename it again, following your directions and the same way I did it the first time.

I got a confirmation of "tablespace altered" but when I tried to bring the tablespace back online I get this error:

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

Tabklespace INDX is still offline.............SYSTEM02.DBF now exists in both directories /ORADATA/ and /oradata_archive/.... In DBA Studio it is showing in the new directory.

With INDX offline can I delete both files? My objective here is to remove this DBF from the DB completely.
Jack







Oracle LazyDBA home page