drop datafile
473071Jun 13 2007 — edited Jan 5 2009Hi mates,
I dropped a newly created datafile in a tablespace that has two datafiles.
The syntax used is : startup mount;
alter database datafile 'c\oradata\ooo.df01' offline drop;
DATABASE ALTERED.
Now the datafile still shows as available in the DBA_DATA_FILES and the OEM..
What could be going wrong?
Do i need to do an os delete?
Is it not possible to drop a datafile atall?
Appreciate any response...
Cheers!!!!