Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> How do a constraint referencing a snapshot field ?
Hi,
How do a constraint referencing a snapshot field ?
The following script doesn't work (returns error message 'ORA-02444: cannot resolve referenced object in referential constraints ') :
>alter table TABLE1
>add constraint FK_TABLE1_SNAPSHOT1 foreign key (FIELD1)
>references SNAPSHOT1 (FIELD1)
(SNAPSHOT1 is a snapshot and TABLE1 is a table).
Thanx Received on Tue Aug 07 2001 - 09:42:11 CDT