Import taking much time for only one table 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

    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
    Bangalore, India
    Import has to read whole 8GB dumpfile to import the specified table.

  3. #3
    Join Date
    May 2003

    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
    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
    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