Oracle DBA, How To, Error, Cause and Action

ORA-04069: cannot drop or replace a library with table dependents

ORA-04069: cannot drop or replace a library with table dependents


Cause:


An attempt was made to drop or replace a library that has dependents. There could be a table which depends on type which depends on the library being dropped.



Action:


Drop all table(s) depending on the type, then retry.

No comments:

Post a Comment

Thanks for your comment.