EXPDP - How To avoid Estimation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXPDP - How To avoid Estimation

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    EXPDP - How To avoid Estimation

    Hi,
    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
    Location
    Lake Worth, FL
    Posts
    1,441

    Talking



    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