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.
Import has to read whole 8GB dumpfile to import the specified table.
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.
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.
The parameters BUFFER, COMMIT and FEEDBACK of imp utility will help you to find out the total time needed for the import.
Click Here to Expand Forum to Full Width