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

Oracle Error Message

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

Reason for the Error

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.

Solution

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