Re: insert into local table user select from remote db

also, try doing a create table as select * from tab_at_db_link;

You might have triggers on local table,

advice still stands to try to trace the session to see what's going on.

On Wed, 16 Feb 2005 18:51:36 +0100, Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl> wrote:

>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
>
>Maybe it is the insert that makes it take longer.
>The nologging option only works together with a hint for the insert,
>like this:
>
>insert /*+ append */ into ...
>
>Please try this and see what the effect is.
>
>Jaap.

.......
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 - 12:54:04 CST