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

Thanks Received on Fri Nov 03 2000 - 08:49:19 CST