Datafile information deleted from control file
710008Jul 4 2009 — edited Jul 5 2009Hi,
I created undo tablespace and associated a path with it.I dropped the tablespace,but did not drop the datafiles.
the dba_data_files view does not show those files.
In the OS,those files exist,but i am not able to drop datafile.
When I do,
SQL> alter database datafile '\usr\lib\oracle\xe\oradata\XE\undo.dbf' offline drop;
alter database datafile '\usr\lib\oracle\xe\oradata\XE\undo.dbf' offline drop
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile "\usr\lib\oracle\xe\oradata\XE\undo.dbf"
Please help...
The files are there physically.