My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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

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