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 NOVEMBER 28, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms