DataPump Export Raises ORA-6502 ORA-39127 When Calling SYS.DBMS_SCHED_JOB_EXPORT.CREATE_EXP
(Doc ID 1122665.1)
Last updated on JULY 02, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You created a new scheduler job with logging level DBMS_SCHEDULER.LOGGING_FAILED_RUNS. During schema/full database exports, DataPump fails with errors:
...
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39127: unexpected error from call to export_string :=
SYS.DBMS_SCHED_JOB_EXPORT.create_exp(457655,'11.01.00.07.00',newblock)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 25
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5569
...
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39127: unexpected error from call to export_string :=
SYS.DBMS_SCHED_JOB_EXPORT.create_exp(457655,'11.01.00.07.00',newblock)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 25
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5569
...
The can be reproduced with the following test:
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |