Home » Other » 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

Report message to a moderator

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?

Report message to a moderator

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: 26766
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.

Report message to a moderator

Previous Topic: How can i use iSQL * plus in my local system
Next Topic: Formatting a string
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 12:57:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.