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

Regarding my last suggestion, I believe it should be:

create or replace view rel_constraints_violated_one as select constrained_rels.constraint_id, constrained_rels.constraint_name, constrained_rels.rel_id, constrained_rels.container_id, constrained_rels.party_id, constrained_rels.rel_type, constrained_rels.rel_segment, constrained_rels.rel_side, constrained_rels.required_rel_segment from ...

and similar for the rel_constraints_violated_two view.