Problem:
DPImport into production:
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "XXX1"."resource352_T" OID '6C5F1FBB7BE11FA7E0440003BA2D252E' AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","resourcename"
VARCHAR2(4000 CHAR),"resourceindex" VARCHAR2(4000 CHAR),"resourceclass" VARCHAR2(4000 CHAR),"resourceclassname" VARCHAR2(4000 CHAR),"string
" "string354_COLL","attribute" "attribute356_COLL")FINAL INSTANTIABLE
Description:
ORA-02304: invalid object identifier literal
Cause: An attempt was made to enter an object identifier literal for CREATE TYPE that is either:
- not a string of 32 hexadecimal characters
- an object identifier that already identifies an existing object
- an object identifier different from the original object identifier already assigned to the type
Solution:
use transform=oid:n
No comments:
Post a Comment