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
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