-
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.
-nagarjuna
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|