Import of an EBS 12.2 Database From 11.2.0.3 to 12.1.0.2 Fails with ORA-39083 (Doc ID 2043765.1)

Last updated on SEPTEMBER 24, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Importing an EBS 12.2 database into 12.1.0.2, after exporting from 11.2.0.3, reports:

ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-01403: no data found
ORA-01403: no data found
Failing sql is:
DECLARE c varchar2(60); nv varchar2(1); df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; s varchar2(60) := 'CSR'; t varchar2(60) := 'CSR_RULES_B'; p varchar2(1); sp varchar2(1); stmt varchar2(300) := 'INSERT INTO "SYS"."IMPDP_STATS" (type,version,c1,c2,c3,c4,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,r1,r2,r3,flags,cl1) VALUES (:1,6,:2,:3,:4,:5,:6,:7,:8,:9,:10 ...

The output of query:

select constraint_name, column_name, position
from dba_cons_columns
where owner='CSR'
and table_name='CSR_RULES_B'
order by constraint_name, position;

shows that a constraint is built on a system generated column:

CONSTRAINT_NAME COLUMN_NAME POSITION
------------------------------ ---------------------------------------- ----------
SYS_C00135560 RULE_ID
SYS_C00135561 OBJECT_VERSION_NUMBER
SYS_C00135562 ENABLED_FLAG
SYS_C00135563 RULE_RANK
SYS_C00135564 CREATED_BY
SYS_C00135565 CREATION_DATE
SYS_C00135566 LAST_UPDATED_BY
SYS_C00135567 LAST_UPDATE_DATE
SYS_C00135568 LAST_UPDATE_LOGIN
SYS_C00135569 SYS_NC0062900630$ 1  <<<<<<<<<<<<<<<<< system generated column

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms