Home > impdp, ORA-XXX > ORA-39083: Object type INDEX_STATISTICS failed to create with error:

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

I import a schema by impdp. There are errors returned as following.

ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-01403: no data found
ORA-01403: no data found
Failing sql is:
DECLARE IND_NAME VARCHAR2(60);   IND_OWNER VARCHAR2(60);   colname DBMS_METADATA.T_VAR_COLL; BEGIN  DELETE FROM “SYS”.”IMPDP_STATS”;   colname(1) := ‘PLAYER_ID’;  DBMS_METADATA.GET_STAT_INDNAME(‘SPORT’, ‘GEN_PLAYER’, colname, 1, ind_owner, ind_name);   INSERT INTO “SYS”.”IMPDP_STATS” (type, version, flags, c1, c2, c3, c5,
n1, n2, n3, n4, n5, n6, n7, n8, n9,
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag “HIST_GRAM_LIST_ITEM” does not match start-element tag “EPVALUE”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 7839

Then I import the schema again with “EXCLUDE=STATISTICS”, it works successfully.  After that I gather the schema statistics by command below.

SQL> exec dbms_stats.gather_schema_stats(‘sport’);

About these ads
Categories: impdp, ORA-XXX
  1. No comments yet.
  1. No trackbacks yet.

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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: