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

/usr/oracle/product/8.1.7/dbs/MISSING00022
AVAILABLE

/usr/oracle/product/8.1.7/dbs/MISSING00023
AVAILABLE

/usr/oracle/product/8.1.7/dbs/MISSING00024
AVAILABLE

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.

er you cannot, that's not the way to remove datafiles, in fact you cannot remove datafiles! if you do that you have to drop the entire tablespace

time to look for another proper dba

pando is right

the fet$ table still references that datafile and at some point will try and allocate an extent from it, at which point you will be in big trouble,

Try to drop objects located in those offline datafiles, then export all objects in tablespace mode.

Recreate the tablespace, then import objects.

or
Try to drop objects located in those offline datafiles
Switch database to archivelog mode
Recover offline databfiles and bring them online
Switch database back to noarchivelog mode

Quote:

---

Originally posted by Calvin_Qiu
Try to drop objects located in those offline datafiles, then export all objects in tablespace mode.

Recreate the tablespace, then import objects.

or
Try to drop objects located in those offline datafiles
Switch database to archivelog mode
Recover offline databfiles and bring them online
Switch database back to noarchivelog mode

---

I doubt you can even drop the objects...

Regarding put in archive log, I dont see how that can help? You need ALL archived logs since datafile creation!