Tad Bytes of Technology
Tips, tricks, and helpful notes.
Pages
Home
Contents
Sunday, May 22, 2011
Drop missing data file on ORA-01110
* May not be appropriate in production env *
Sometimes in test env, if a datafile, which is no longer required, is deleted without first dropping the tablespace, then to cleanup:
startup mount;
alter database datafile '
' offline drop;
alter database open;
drop tablespace
including contents;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment