hi,
i'm need help in moving object from one table space to the other.
e.g i have in tablespace A, a type definition PERSON

TYPE PERSON AS OBJECT (
NAME VARCHAR2(60),
EMAIL VARCHAR2(60),
GENDER VARCHAR2(1)
)

and in the EMPLOYEE table, i have a field with PERSON as an object.


Now, i want to move an entry from table EMPLOYEE in tablespace A to table EMPLOYEE into tablespace B.

when i try to do directly reference A.PERSON = B.PERSON, i get the following error.
PL/SQL: ORA-00932: inconsistent datatypes: expected A.PERSON got B.PERSON

Can somebody help?

thanks and best regards,
Kalyan