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

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.