Import taking much time for only one table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Import taking much time for only one table

  1. #1
    Join Date
    May 2003
    Posts
    12

    Question Import taking much time for only one table

    I imported one 8 GB dump file into test environment ( test_db01 ).
    One table ( table_01 ) did not get populated because of wrong table definition in test environment ( test_db01 ).

    I corrected the table definition of table_01.
    Started the import again; this time only for table_01.
    (using the "TABLES=(table_01)" parameter in the parameter file; I used the same 8 GB dump file for import)

    Almost half an hour went. But still the import is not ending and not showing any messages.

    Of course I could have taken an individual export of table_01 and imported it quickly.
    But wanted to know why import is taking so much time just for one small table.

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Import has to read whole 8GB dumpfile to import the specified table.
    -nagarjuna

  3. #3
    Join Date
    May 2003
    Posts
    12

    Thumbs up

    Thanks Nagarjuna. That must be the reason for the delay.
    ( Finally my import was over after one hour !! )

    Next time atleast I wont panic if it takes time.

  4. #4
    Join Date
    May 2001
    Posts
    736
    If u have gone through the documentation it clearly say that export and import for data size of xGB will take hours to complete.This is the greatest disadantage of this utility.

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The parameters BUFFER, COMMIT and FEEDBACK of imp utility will help you to find out the total time needed for the import.

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