DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2000
    chennai,tamil nadu,india

    EXPDP - How To avoid Estimation

    I am at present running exp and we recently upgraded to 10g v2.We thought of going with expdp.Since we have almost 50,000 tables for that schema,the estimation process(blocks & statistics) taking almost the time it took for completion of exp.

    Is there any way to suppress estimation???.I tried estimate_only=n and it didnt work???.Any suggestions.

  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL


    Use regular export instead of expdb.

    But export backup is useless unless you actually know which tables you would have to recover from the 50,000.

    Better just backup with rman.

    Last edited by LKBrwn_DBA; 10-28-2007 at 09:22 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.