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.