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 03, 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) := '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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.