ORA-22814 Error Reported When Loading USER_PREF_STATISTICS With DataPump Export (EXPDP) (Doc ID 2224329.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The errors below are reported while executing expdp job in 11.2.0.4:

and running this statement in SQL*Plus, fails with the same error:

SQL> SELECT OBJ_NUM,SYS_XMLGEN(VALUE(KU$),XMLFORMAT.createFormat2('T_USER_PREF_STAT_T','7')) col1
FROM SYS.KU$_USER_PREF_STATS_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS,128)!=0
AND KU$.BASE_OBJ.NAME NOT LIKE 'ASK%' AND KU$.BASE_OBJ.NAME NOT LIKE 'AQ$%' and OBJ_NUM =92061;
ERROR:
ORA-22814: attribute or element value is larger than specified in type

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