4 Replies Latest reply: Nov 1, 2012 10:26 AM by User286067 RSS

    Not able to find the estimate size of the schema by the expdp parameter

    928199
      Hi All,

      We are using 11.1.0.7 database, we want to find out the estimate size of the schema by the DATAPUMP parameter estimate_only=Y.

      But the sessions goes into the hang state or not processing further:

      Please advise,size of the schema is below:

      SQL> select sum(bytes/1024/1024/1024) from dba_extents where owner='BOB';

      SUM(BYTES/1024/1024/1024)
      -------------------------
      1941.12512
      Please advise if we can take the export or find out the estimate size of the schema,which is around 2TB.