Hi Ankit Sood,

Try to disable triggers, indexes, constraints and replication on the slow
tables.

Bas Wesselink

Bas Wesselink
Formido Hoofdkantoor
t:+31(0)33 2 47 45 27
f:+31(0)33 2 47 45 16



-----Oorspronkelijk bericht-----
Van: Sood Ankit (GE Consumer Finance consultant)
[mailto:oracledba-ezmlmshield-x28963227.[Email address protected]
Verzonden: dinsdag 28 februari 2006 8:41
Aan: LazyDBA Discussion
Onderwerp: 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

Oracle LazyDBA home page