Re: How do a constraint referencing a snapshot field ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 7 Aug 2001 20:41:53 +0200
Message-ID: <997209715.18381.0.pluto.d4ee154e@news.demon.nl>

<ytroadec_at_spir.fr> wrote in message news:3b6fe5dd.0_at_morille...
> 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
>
>

This is not possible.

Sorry

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 07 2001 - 13:41:53 CDT