1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
|
Connected to Oracle9i Enterprise Edition Release 9.2.0.5.0
Connected as mni
SQL>
SQL> create table border (
2 country1 varchar2(2),
3 country2 varchar2(2),
4 dist number
5 )
6 /
Table created
SQL> alter table border
2 add constraint pk_border primary key (country1, country2)
3 /
Table altered
SQL> CREATE MATERIALIZED VIEW LOG ON border with rowid
2 /
Materialized view log created
SQL> create materialized view border_mv
2 refresh fast on commit
3 as
4 select rowid crid, country2 a, country1 b, 1 umarker
5 From border
6 UNION ALL
7 select rowid crid, country1 a, country2 b, 2 umarker
8 From border
9 /
Materialized view created
SQL> alter table border_mv
2 add constraint uk_border_mv unique (a, b)
3 /
Table altered
SQL> insert into border values ('FR', 'BE', 1200)
2 /
1 row inserted
SQL> insert into border values ('BE', 'FR', 1200)
2 /
1 row inserted
SQL> commit
2 /
commit
ORA-12008: erreur dans le chemin de régénération de la vue matérialisée
ORA-00001: violation de contrainte unique (MNI.UK_BORDER_MV)
SQL> |
Partager