Expdp Hangs During Exporting Data Due to a Lock Situation (Doc ID 756834.1)

Last updated on AUGUST 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 10-Feb-2016***

Symptoms

DataPump export hangs during execution:

#> expdp system/oracle tables=scott.emp dumpfile=emp.dmp exclude=statistics

 

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "SCOTT"."DEPT"          5.656 KB          4 rows

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