Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How do a constraint referencing a snapshot field ?
Sybrand Bakker <postbus_at_sybrandb.demon.nl> a écrit dans le message :
997209715.18381.0.pluto.d4ee154e_at_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
>
>
Hi,
For your information, after some tries, i could do it by referencing the physical snapshot table with the script :
alter table TABLE1
add constraint FK_TABLE1_SNAPSHOT1 foreign key (FIELD1)
references SNAP$_SNAPSHOT1 (FIELD1)
Is it the only solution ?
Thanx. Received on Wed Aug 08 2001 - 03:31:35 CDT