Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to add a deleted datafile again
The scenario is
I have deleted a datafile belonging to a Tablespace say A using the command
ALTER DATABASE DATAFILE 'a1.dbf' offline drop;
The datafile exists in the same location .Its not physically deleted from the disk.
Now i want to add the datafile again back to the Tablespace.
What do i need to do
-- Message posted via http://www.oraclemonster.comReceived on Tue Feb 08 2005 - 04:38:29 CST