1 Reply Latest reply: Nov 2, 2012 2:11 AM by Sunny kichloo RSS

    expdp is hung

    Tom
      version:11.2.0.2 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 11.2.0.2.0 - 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...
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
      <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.