To do this ADM_EL must have the references privilege on the
table ADM_MGE.MAPS.
That is ADM_MGE must execute the statement:
grant references on MAPS to ADM_EL;
Patrice Leclerc a écrit dans le message <7qm6c9$7ie$1_at_news.quebectel.com>...
>I try to execute this and I have the following error:
>ORA-00942 table or view does not exist.
>
>SQL> ALTER TABLE ADM_EL.EL_ENTREE_ELECTRI ADD (
> 2 CONSTRAINT EL_EE_MAP_FK1
> 3 FOREIGN KEY (MAPID)
> 4 REFERENCES ADM_MGE.MAPS (MSLINK)
> 5 )
> 6 ;
> REFERENCES ADM_MGE.MAPS (MSLINK)
> *
>ERROR at line 4:
>ORA-00942: table or view does not exist
>
>The table MAPS exist and I have also create a public synonym MAPS on
>ADM_MGE.MAPS
>
>Please help me.
>
>---------------------------------
>Patrice Leclerc
>patricel_at_mobilis.qc.ca
>Systemes Mobilis
>
>
Received on Thu Sep 02 1999 - 11:24:31 CDT
