How to remove the offline drop datafiles
One of our dba added a 3 datafile to a tablespace and he issued offline drop on all the datafiles he created on a noarchivelog mode
DB.We tried to recreated the controlfile by avoiding this datafiles.
Now when i select from the dba_datafiles it shows something like this
My DB is working perfectly fine but my export has a entry saying the tablespace related to this datafiles were offline.I checked the status of the tablespaces its online.
Anyone know how to remove this entry permanently without any recreation of tablespace since this tablespace has lot of objects in it.