My Oracle Support Banner

Data Pump Export (expdp) or Data Pump Import (impdp) reports ORA-21780 at the end of export completion. (Doc ID 1357811.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

expdp tc1/tc1 parfile=test.par

Export: Release 11.2.0.1.0 - Production on Wed Oct 13 13:23:23 2010

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

Connected to: Oracle Database 11g Enterprise Edition Release
11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
Starting "TC1"."TEST": tc1/******** parfile=test.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 320 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

... lines truncated ...

Master table "TC1"."TEST" successfully loaded/unloaded
*******************************************************************
Dump file set for TC1.TEST is:
/tmp/expdat.dmp
ORA-39097: Data Pump job encountered unexpected error -21780
ORA-39065: unexpected master process exception in DISPATCH
ORA-21780: Maximum number of object durations exceeded.


IMPACT

ORA-39097: Data Pump job encountered unexpected error -21780
ORA-39065: unexpected master process exception in DISPATCH
ORA-21780: Maximum number of object durations exceeded.


TEST CASE

1. Prerequisites

   connect / as sysdba

   -- create test user
   create user tc1 identified by tc1 default tablespace users;
   grant dba to tc1;

   -- Create Data Pump directory
   create or replace directory DP_TEST as '/tmp';

   -- Create a parameter file (test.par) to include the following parameters:
   directory=DP_TEST
   job_name=TEST
   LOGFILE=test.log
   SCHEMAS=SYSTEM
   parallel=4

2. Run the test case. You need 2 separate sessions:

   -- session #1: initiates the export
   rm /tmp/*.dmp
   expdp tc1/tc1 parfile=test.par

   -- session #2: Changes parallel to 1.
   expdp tc1/tc1 attach=TEST 
   Export> parallel=1
   Export> exit


NOTE
----
To reproduce the issue it is essential to execute the "parallel=1" command *after* the
"total estimation" message has been reported:

Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 320 KB <== don't execute "parallel=1"
                                              before this message appeared.




Changes

Changed number of parallel processes while Data Pump Export or Import was running.

Export> parallel=1
Export> exit

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.