Finding dependent objects of a UDT

Database
Enthusiast

Finding dependent objects of a UDT

Hi All,

I am getting the error message "Failure 6839 'DROP TYPE' operation on 'udt1' not allowed: Referenced by other object(s)." when i am trying to drop a UDT. From the docs i am able to find we can drop a UDT only after cleaning up all of the following objects...
* Tables that use the UDT.
* Structured UDTs that use the UDT for one or more attributes.
* UDFs that use the UDT as a parameter type.
* UDMs that use the UDT as a parameter type.
* Casts associated with the UDT.
* Orderings associated with the specified UDT.
* Transforms associated with the specified UDT.

Is there any command to find the dependent objects of a UDT. I think we can get the dependent cast using HELP CAST and drop that using DROP CAST command. Similarly we can do it for Ordering and transform associated to a UDT using DROP ORDERING FOR ; and HELP TRANSFORM ; DROP Transform command respectively. But i am not getting the options for finding the other referenced objects.

Can any one help me out in solving this problem. Is there any command similar to DROP ... Cascade in oracle which drops the dependent objects as well.

1 REPLY
Enthusiast

Re: Finding dependent objects of a UDT

Have you tried using DBC.Columns view ? there's a columnUDTName field which might help.