how can I recover if a datafile is drop without backup !
Dear Friends,
I have a query .
In oracle database 10g , I created a test database name 'support' . I created a tablespace 'support_ts' here .
In my absent mind , I deleted the datafile which is associated to "support_ts" physically .Logically the tablespace information is in database but physically the datafile is deleted .
'SUPPORT' database has no backup (export and rman ) ,also the database is in noarchivelog mode .
In this moment , is it possible to recover it or can i focely remove the tablespace information from database ? so that , in next startup database don't search the "support_ts" tablespace information ?