Database Utilities (MOSC)

MOSC Banner

imp/exp of xmlType objects in 10.2

edited Jul 7, 2010 3:43AM in Database Utilities (MOSC) 2 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center