Re: Help insert with a select using a DB Link - ORA-03106: fatal two-task communication protocol error

There is a lot of stuff on Metalink regarding this error.

put the session in SQL_TRACE and see where it is happening. Then you will have to put SQL*NET into trace and see which host or protocol layer it's happening in.

Does it work as CTAS ?

"Don" <annon_at_someaddress.com> wrote in message news:qumeju456951u6053irvo7dt602d2qr3al_at_4ax.com...
> I have an INSERT statement that inserts into a table based on the
> result of a SELECT statement. This select statement uses two views
> (outer joined) through a databas link.
>
> I get the following errors when I execute this SQL:
> ORA-03106: fatal two-task communication protocol error
> ORA-02063: preceding line from DBLINK1
> ORA-02063: preceding 2 lines from DBLINK1
>
>
> The insert statement has 21 columns. One of these columns uses 2
> concate functions in the select portion (ex. CONCATE((CONCATE(a,b),c))
> .
> For brevity here is an example of what I am doind. Only the field
> names are different.
> INSERT INTO table (
> columns ...)
> (SELECT columns...
> FROM table1_at_dbLink1, table2_at_dblink1
> WHERE table1.field = table2.field(+)
> );
>
> When I run the select portion by itself it works fine. It will return
> about 2.5 million rows so I know the insert will be slow.
>
> To get the data there are a series of DB links that span 4 machines
> (counting my server).
> The views used by this select statement are based on views on another
> server (using a DB Link). These source views are based on Tables from
> another server (using a DBLink). Should this matter? It's still a
> view to my system - how it is populated should not matter. All my
> queires on these views work.
>
> Any idea what causes these errors? I have search newsgroup archives
> and the few references to these errors are only question - no answers.
>
> Thanks for any help,
> Don
>
Received on Fri Jul 19 2002 - 03:39:52 CDT