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

"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
>

This must be a lousy network, and I don't think anyone even wants to build recursively distributed solutions. Think about it: you have a distributed transaction between server a and server b and server b and server c. Any glitch and you are toast.

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address