Forum OpenACS Q&A: Response to Installation of ACS 4.2 and Oracle 9i on Linux

Don, I don't think the outer join can be dropped altogether, only the ambiguity of using the equality operator (=) on NULL columns; so, for the rel_constraints_violated_one view I think it should be:
where rspm.segment_id(+) = constrained_rels.required_rel_segment
and constrained_rels.container_id is null
and rspm.party_id is null;
and for the rel_constraints_violated_two view:
where rspm.segment_id(+) = constrained_rels.required_rel_segment
and constrained_rels.party_id is null
and rspm.party_id is null;