This content has been marked as final. Show 2 replies
Is this your test database?
I recommend you backup your database in a state what it is now before procedding to any of the mentioned solution here.
And before procedding below do you like to post where it shows that datafiles got corrupted?
You need to offline your datafile at the mount stage.
alter database datafile 'datafile name' offline alter database open drop tablespace <tablespace name> drop including contents
PS: All the above commands are irrecoverable if you do not have a backup.