Sood Ankit,
Did you disable the indexes and constraints?


-----Original Message-----
From: Sood Ankit (GE Consumer Finance consultant)
[mailto:oracledba-ezmlmshield-x28963227.[Email address protected]
Sent: Tuesday, February 28, 2006 2:41 AM
To: LazyDBA Discussion
Subject: imp is slow


Hi All,
I am having scenario where I have to truncate/drop the table and recreate the table again and import the transaction data for some.Imp is running very slow for few tables.
I am not sure where is the problem.Total dump size is 2GB but imp is taking more time for 3 tables only.
If any one can give some feedback that will be great help.





> Regards,
> Ankit Sood
GE Consumer Finance Co.
Japan.
> Phone: +81-42-330-8734
> Mobile No:+81-9098429482
Email:ankit.[Email address protected]



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

Oracle LazyDBA home page