Does TOAD not show you the 'OTHER'
column from the execution plan ? If not,
run your SQL through a proper 'explain plan'
tool and you will be able to see the SQL
that is actually sent to the remote database.
This may confirm your suspicion.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
bonminh lam wrote in message
<3c6b1bcf.0109080745.2fbe3146_at_posting.google.com>...
>The query in question looks like this
>
>INSERT INTO lam_t1
>SELECT *
>FROM facts_at_db_link
>WHERE month = TRUNC('01 07', 'rrmm')
>;
>
>The execution plan shown by T.O.A.D (I am trying to put it togehter
>from memory now as I am not in the office now) looks like this:
>
>INSERT
> FILTER
> REMOTE*
>
Received on Wed Sep 12 2001 - 11:14:27 CDT
