| Ratnaker |
Posted: Sep 24, 2007 05:48:43 AM |
Total Post: 136
Joined: Apr, 2007
|
HI all,
I have exported dumpfile, I want to import into in to my another database but its taking long time. Please any one can help for import faster.
Ratnaker |
|
|
 parthokonar |
| Posted: Sep 24, 2007 08:31:11 AM |  |
|
Total Post: 27
Joined: Sep, 2007
|
Hi it can depend on the number of parameters like buffers, consistent, whether the indexes are enabled or disabled. After that we can analyse better what is happening.
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Sep 25, 2007 05:03:38 AM | |
|
Total Post: 226
Joined: Aug, 2007
|
Ratnaker try to drop the constraints/Indexes , first import and then create/enable them. When you importing if these are enabled then it will try to create index and search for parent key etc., so will take some time
|
|
|
|
|
| Ratnaker |
| Posted: Oct 01, 2007 01:20:23 AM | |
|
Total Post: 136
Joined: Apr, 2007
|
Hi Ramesh and parth,
Thank you for giving me to good suggestion.
Ratnaker
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 02:57:38 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
