Wednesday, July 25, 2018

How to drop physically deleted tablespace file

First run select * from v$datafile; to get the FILE#.

Then run select NAME from v$datafile where file#=39; to verify the tablespace name.

Then run alter database datafile 39 OFFLINE DROP; to drop

No comments:

Post a Comment