RE: ora 3113 and ora 7445 when using outer join over db link

Hi Babu,

I had a simular problem recently on DG/UX (same messages). Workaround was to use aliases for the tables/views in the from-list(s). Let us know if it works.

Remco

> ----------
> From: Babu.Nagarajan_at_Cummins.com[SMTP:Babu.Nagarajan_at_Cummins.com]
> Sent: vrijdag 3 november 2000 15:50
> To: Multiple recipients of list ORACLE-L
> Subject: ora 3113 and ora 7445 when using outer join over db link
>
> Hi
>
> I have two views A and B that use db_links. I create a view C that does a
> outer join on A and B. When I do a select from A or B they work fine. If I
> do a select on C then the session ends with ora-3113. I also get a
> ora-7445
> in the background.
>
> If i do a create table table_a as select * from A and create table table_b
> as select * from B and then modify C so that it selects from table_a and
> table_b then the select works fine. Also if I remove the outer join but
> let
> C depend on A and B then again the select works fine.
>
> I searched Metalink for a bug when using outer-joins on db_links but I
> coul
> dnot find one.. My db is 8150 and OS is Digital Unix 4.0f.
>
> Any similar experiences or ideas...
Received on Fri Nov 03 2000 - 09:58:03 CST