Re: insert into local table user select from remote db

What's 'long time'?

try tracing the session

On 15 Feb 2005 13:30:00 -0800, zibinyang_at_gmail.com wrote:

>Hi All,
>When I use select * from aaa_at_db_link, it's works fine less then 10
>seconds.
>but when I try to user insert into local_table as select * from
>aaa_at_db_link, it's take long time to run, I also tried to use nologging
>option. I know it's not use index, is there anyother way to do this
>other then export/import?
>
>Thanks
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Feb 15 2005 - 16:38:53 CST