My Oracle Support Banner

DataPump Job Fails To Start Due to ORA-31633 And ORA-06502 (Doc ID 2226152.1)

Last updated on AUGUST 25, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

- Launching a DataPump job in a database where all registry components are valid, fails with:

> expdp system/<PASSWORD> directory=EXPORT_DIR SCHEMAS=SCOTT dumpfile=dp_SCOTT.DMP LOGFILE=dp_SCOTT.LOG

Export: Release 12.1.0.2.0 - Production on Mon Jan 23 11:39:43 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

- The classic export and import work fine in this database.

- Cleaning up the orphaned Data Pump jobs by executing the steps from Doc ID 336014.1 didn't help.

- The error message indicates that the master table for DataPump job could not be created.

Changes

 NONE

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


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