Julian,
You may try to rewrite the two views and to explicitly specify the column names, i.e.:
create or replace view rel_constraints_violated_one as
select constraint_id, constraint_name, rel_id, container_id, party_id,
rel_type, rel_segment, rel_side, required_rel_segment
from ...
create or replace view rel_constraints_violated_two as
select constraint_id, constraint_name, rel_id, container_id, party_id,
rel_type, rel_segment, rel_side, required_rel_segment
from ...
I read somewhere that the "lazy" way of creating views (e.g.
select constrained_rels.*
instead of explicitly specifying the column names) results in Oracle crashing when a view's base table has been dropped and recreated with columns in different order or with extra columns. Bottom line: always,
explicitly specify the columns when creating a view.