Oracle Error Codes

cannot create a type that already has valid dependent(s)

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).

How to Solve :

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