ORA-06512 ORA-39127 ORA-06502 numeric or value error: character string buffer too small

While I was taking the full database export using expdp, for some of the scheduler jobs export I faced below issue.

ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.CREATE_EXP(71840,’11.02.00.00.00′,newblock)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “SYS.DBMS_SCHED_JOB_EXPORT”, line 26
ORA-06512: at line 1
ORA-06512: at “SYS.DBMS_METADATA”, line 8775
ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.CREATE_EXP(71844,’11.02.00.00.00′,newblock)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “SYS.DBMS_SCHED_JOB_EXPORT”, line 26
ORA-06512: at line 1
ORA-06512: at “SYS.DBMS_METADATA”, line 8775
ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.CREATE_EXP(71848,’11.02.00.00.00′,newblock)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “SYS.DBMS_SCHED_JOB_EXPORT”, line 26
ORA-06512: at line 1
ORA-06512: at “SYS.DBMS_METADATA”, line 8775

I have searched oracle metalink and googled a lot and was not able to find the solution. The work around I found for this is ,taking export using the “exclude=PROCOBJ” clause.
expdp directory=DATAPUMP_BKP dumpfile=full.dmp logfile=full.log exclude=PROCOBJ
…………………
………………….
Master table “SYS”.”SYS_EXPORT_FULL_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  /u01/app/oracle/product/11.2.0.3/rdbms/log/full.dmp
Job “SYS”.”SYS_EXPORT_FULL_01″ successfully completed at 12:27:54
Dump got completed successfully completed.
After that I started the dump only for scheduled jobs like below.
expdp include=PROCOBJ dumpfile=PROCOBJ.dmp logfile=PROCOBJ.log directory=DATA_PUMP_DIR full=y content=all
Again it got above error messages. The export is getting failed only for 71840,71844,71848 objects. I took the DDL manually and created it in the destination database.

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 )

Connecting to %s