Re: insert into local table user select from remote db

The cursor will propably only increase the network overhead

How big is the table? I'd advise trying to trace the session

On 16 Feb 2005 06:25:20 -0800, zibinyang_at_gmail.com wrote:

>More then 20 minutes, I had tried to use cursor to do this with in a
>loop.
>But still not good.
>Thanks
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Feb 16 2005 - 10:15:55 CST