ORA-39083: Object type TYPE failed to create with error

SYMPTOMS

While importing ORMB schemas from default installation to new schemas for another new ORMB environment.

$impdp directory=DUMP_DIR dumpfile=ORMB.dmp REMAP_TABLESPACE=CISTS_01:CISADM_1 SCHEMAS=CISADM,CISUSER,CISOPR,CISREAD REMAP_SCHEMA=CISADM:CISADM_1,CISUSER:CISUSER_1,CISOPR:CISOPR_1,CISREAD:CISREAD_1,CIS_USER:CIS_USER_1,CIS_READ:CIS_READ_1 logfile=imp_cisadm_2_cisadm_1.log  
...
..
.
CREATE TYPE "CISADM"."TY_RMB_DELETE_BILL_TAB"   OID '40ACB20E52264074E053530F040AF48D' AS TABLE OF "CISADM"."TY_RMB_DELETE_BILL_DTL"
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal

SOLUTION

Add “transform=OID:n” as impdp parameter.

$impdp directory=DUMP_DIR transform=OID:n dumpfile=ORMB.dmp REMAP_TABLESPACE=CISTS_01:CISADM_1 SCHEMAS=CISADM,CISUSER,CISOPR,CISREAD REMAP_SCHEMA=CISADM:CISADM_1,CISUSER:CISUSER_1,CISOPR:CISOPR_1,CISREAD:CISREAD_1,CIS_USER:CIS_USER_1,CIS_READ:CIS_READ_1 logfile=imp_cisadm_2_cisadm_1.log
Advertisements
This entry was posted in DataPump, ORA- ERRORS, ORMB and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s