Try to drop objects located in those offline datafiles, then export all objects in tablespace mode.
Recreate the tablespace, then import objects.
or
Try to drop objects located in those offline datafiles
Switch database to archivelog mode
Recover offline databfiles and bring them online
Switch database back to noarchivelog mode
Last edited by Calvin_Qiu; 09-10-2003 at 10:28 PM.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Reply With Quote