Data Pump utility
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Data Pump utility

  1. #1
    Join Date
    Feb 2009
    Posts
    3

    Exclamation Data Pump utility

    Hello,

    Well i was using the impdp command and found something weird. I was importing a tablespace that had 184 tables using the impdp command. But, the impdp command usually seems to import only 164 tables and misses out on a random 20 tables. Is there any solution to avoid this situation ?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    evidence? errors?

  3. #3
    Join Date
    Feb 2009
    Posts
    3
    well there are no errors. just that the original dumpfile had around 184 tables and after the impdp command when i performed a count operation, it showed that there are only 164 tables.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Do you have the log file from the export?
    Does it confirm the number of tables and that it was successful ?
    I remember when this place was cool.

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    could be tables in recycle bin playing the trick... purge recyclebin and tell us the table count.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I wouldn't start troubleshooting until seeing both expdp and impdp logs and scripts.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    Quote Originally Posted by Thomasps View Post
    could be tables in recycle bin playing the trick... purge recyclebin and tell us the table count.

    DBA_SEGMENTS will reveal that, you can sort it by owner or tablespace, any tables (or objects) in there will have a generic name starting with BIN$xxxxx under SEGMENT_NAME.
    I remember when this place was cool.

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