ORACLE Tips

ORACLE Tips

Q) How can I drop tablespace if a datafile is missing?

Ans)
startup mount
alter database datafile '/path/to/filename' offline drop;
alter database open;
drop tablespace tbsp_name including contents cascade constraints;