copy oracle table between schema's with user defined Array datatype

Hello experts. I recently imported a schema into another test schema. Several tables did not come through even though I had replicated the user object and array types prior to the import.
I am trying to recreate these problem tables manually but I cannot get the data to come across.

First I tried to create table hpms_validate_log as select * from old_schema.hpms_validate_log. I receive the following error : ora-00902: invalid datatype.

Second I created the table hpms_validate_log from the old_schema's DDL then tried to insert the values.
insert into hpms_validate_log (select * from old_schema.hpms_validate_log)
I received this error message: ORA-00932 inconsistent datatypes expected new_schema.cross_va got old_schema.cross_va.    
CROSS_VA is the ARRAY type which is made up of object type CROSS_TY.
CROSS_TY is two varchar 2 fields.
I have verified these ARRAY and OBJECT types are identical between the two schemas.

Thanks for the assistance.Start Free Trial