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.com