Home » SQL & PL/SQL » Client Tools » Importing Table using Pl/Sql Developer (merged)
Importing Table using Pl/Sql Developer (merged) [message #384476] Wed, 04 February 2009 00:33 Go to next message
podu
Messages: 1
Registered: February 2009
Location: Bangalore
Junior Member
Hi,
I am trying to import table using Import feature of Pl/Sql developer. But this process seem to be very slow. For a table having 5oK records it took 16-17 hours.
I tried transferring data from prod to dev environment(Same thing what I was doing using expoert/import feature of pl/sql developer tool) using Informatica and it finoshed within minutes.

I want to know the reason why pl/sql developer is so slow in comparison to informatica?

Thanks,
mahesh
Re: Importing Table using Pl/Sql Developer (merged) [message #384620 is a reply to message #384476] Wed, 04 February 2009 08:58 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I guess it's badly written.

Why not use IMP and EXP - the impore and export tools that Oracle provide?
Re: Importing Table using Pl/Sql Developer (merged) [message #384623 is a reply to message #384476] Wed, 04 February 2009 09:05 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Why not use IMP and EXP - the impore and export tools that Oracle provide?
No GUI wrapper & OP would have to do more than point & click.
Previous Topic: How can i use iSQL * plus in my local system
Next Topic: Formatting a string
Goto Forum:
  


Current Time: Tue Dec 06 14:15:10 CST 2016

Total time taken to generate the page: 0.12007 seconds