Hi all,
We have a test database , the one and only one datafile of the users tablespace was replaced with a old backupfile backedup before the resetlogs. now we are not able to recover this file. So what can be done to continue using the tablespace. We added another datafile. but still users are not able to create tables onm this datafile. it stills points the error to the corrupt datafile only. Can we drop the tablespace and create new tablespace. Or is there any other method , pls do advice