Database Error Messages

An attempt was made to DROP or REPLACE a type that has type or table dependents.

For DROP TYPE, drop all types and tables depending on the type and then retry the operation, or use the FORCE option.

For CREATE TYPE, drop all types and tables depending on the type and then retry the operation, or drop all tables depending on the type and retry with the FORCE option.

This query lists the dependent objects:

SELECT owner, name, type FROM all_dependencies WHERE referenced_name = '<type_name>' AND referenced_owner = '<type_owner>';

An attempt was made to drop or replace a type that has type or table dependents.

For DROP TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or use the FORCE option. For CREATE TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or drop all table(s) depending on the type and retry with the FORCE option.

An attempt was made to drop or replace a type that has type or table dependents.

For DROP TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or use the FORCE option. For CREATE TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or drop all table(s) depending on the type and retry with the FORCE option.