Compare User Objects - Dependant types

[rjoffe]

When comparing two schemas, we often run into dependancy issues with types.

For example, I have two types, one is a table of objects, and the other is a table of the first type:

create or replace type T_object as object (
var1 number
,var2 number);

create or replace type T_table as table of
T_object;

It is very typical for us to change the T_object specification. in order for us to apply this change, we have to drop the T_table type, and recreate it. When comparing two schemas, we would like to see an option of "drop and recreate referenced type objects" or something similar.

Thanks,

Ron

 

[Marco Kalter]

I have added this to the list of enhancement requests.