Pages

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