Oracle DBA, How To, Error, Cause and Action

ORA-02306: cannot create a type that already has valid dependent(s)

ORA-02306: cannot create a type that already has valid dependent(s)




Cause: An attempt was made to create a type that already has some valid dependent(s) (these dependents depend on the fact that the type does not exist).




Action: Drop the dependents first before creating the type, or do not create the type.