Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

During a full export of my Oracle 10.2.0.2 database, I encounter the following warnings

[...]
. 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 102269
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 102271
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 102273
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.

I looked for these three objects querying dba_objects with their object_id and it returns

  • ADV_SQLACCESS5150248
  • ADV_SQLACCESS9067727
  • ADV_SQLACCESS2676493

Are these warnings worrying?

How should I fix them and what is going on exactly?

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

I expect this is bug 5120780 fixed in 10.2.0.4 (a quick search on Metalink would have told you).

share|improve this answer
1  
Thanks for the answer. I probably would have find it on metalink should I be able to login, but our previous DBA left with the Customer Support Identifier needed to create an account... We are struggling to get it back. I'm an interim DBA trying to do his best..! –  LudoMC Jan 25 '11 at 10:21
    
Good luck! You should have an account manager at Oracle who can retrieve it for you. –  Gaius Jan 25 '11 at 10:28
add comment

Gaius is correct.+1 In case someone else has this problem in the future, it is known to occur on 10.1.0.2 to 10.2.0.3 on any platform. In addition to upgrading to 10.2.0.4, Patch 5120780 can be applied to fix this problem. The patch is available for a limited set of platforms.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.