Database Utilities (MOSC)

MOSC Banner

10g export with 'ORA-06502' character string buffer too small - when calling SYS.DBMS_SCHED_JOB_EXP

edited Jul 20, 2010 10:11AM in Database Utilities (MOSC) 9 commentsAnswered
Hi Everyone:

May I ask if is it 'ignorable warnings' or error that must be fixed?

My oracle is 10.2.0.1.  Recent daily night export log gives me the below message at its end of log output:


. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_JOB_EXPORT.
create_exp for object 128481
. exporting user history table
. exporting default and system auditing options

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center