My Oracle Support Banner

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 FEBRUARY 26, 2019

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) := '<SCHEMA_NAME>'; t varchar2(60) := '<TABLE_NAME>'; 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='<SCHEMA_NAME>'
and table_name='<TABLE_NAME>'
order by constraint_name, position;

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

CONSTRAINT_NAME COLUMN_NAME POSITION
------------------------------ ---------------------------------------- ----------
SYS_C00135560 <COLUMN_NAME1>
SYS_C00135561 <COLUMN_NAME2>
SYS_C00135562 <COLUMN_NAME3>
SYS_C00135563 <COLUMN_NAME4>
SYS_C00135564 <COLUMN_NAME5>
SYS_C00135565 <COLUMN_NAME6>
SYS_C00135566 <COLUMN_NAME7>
SYS_C00135567 <COLUMN_NAME8>
SYS_C00135568 <COLUMN_NAME9>
SYS_C00135569 SYS_NC0062900630$ 1  <<<<<<<<<<<<<<<<< system generated column

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.