Transfering data with object types between schemas.

Hi all,

I have two schemas, S1, S2 both containing a table T whose attributes (some of them) have object types.

In schema S1, the statement (all necessary grants provided)

insert into T select * from S2.T;

produces the error ORA-00932: inconsistent datatypes: expected S1.<typename> got S2.<typename>

A colleague of mine has written a function for transforming the attribute value, but it is type specific and must be applied to each attribute (so that * cannot be used), which complicates matters

when such statements are generated by another SQL statement.

I wonder if there is any system tool for such remapping.