imp/exp of xmlType objects in 10.2
Dear experts,
If I do an export of database schema containing xmlType columns using exp and then try to import it into another schema using imp, I get following errors in imp log:
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "Annotation221_T" TIMESTAMP '2010-05-18:09:56:01' OID '89767114"
"8F604EB7A32B3A2208462222' AS OBJECT ("SYS_XDBPD$" "XDB"
""."XDB$RAW_LIST_T","PropertyName" VARCHAR2(4000 CHAR),"Purpose" VARCHAR2(40"
"00 CHAR),"Language" VARCHAR2(4000 CHAR),"Text" VARCHAR2(4000 CHAR))NOT FINA"
"L INSTANTIABLE "
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
Of course all tables containing the Annotation221_T column are not imported as well.
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "Annotation221_T" TIMESTAMP '2010-05-18:09:56:01' OID '89767114"
"8F604EB7A32B3A2208462222' AS OBJECT ("SYS_XDBPD$" "XDB"
""."XDB$RAW_LIST_T","PropertyName" VARCHAR2(4000 CHAR),"Purpose" VARCHAR2(40"
"00 CHAR),"Language" VARCHAR2(4000 CHAR),"Text" VARCHAR2(4000 CHAR))NOT FINA"
"L INSTANTIABLE "
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
Of course all tables containing the Annotation221_T column are not imported as well.
0