This discussion is archived
1 Reply Latest reply: Nov 2, 2012 12:11 AM by Sunny kichloo RSS

expdp is hung

Tom Newbie
Currently Being Moderated
version: on RHEL 5.4

We have started the export of 6 schemas with the combined size of 70GB . I've set COMPRESSION=ALL and PARALLEL=5
It is stuck like below for 1 hour and 30 minutes.

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

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SDMB_PRLS_UAT"."SYS_EXPORT_SCHEMA_02":  SDMB_PRLS_UAT/******** parfile=expdp.par
Estimate in progress using BLOCKS method...
<not proceeding from here>
I've noticed the following FLASHBACK thing in the output. Could this be the cause? If so, how can I disable it ?
FLASHBACK automatically enabled to preserve database integrity.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points