Re: Referencing SYS.DBA_USERS ???

Hi there,

 There is no table called DBA_USERS !! It is a view !

John K.
johnkoo_at_i-wave.net

news.logica.com (GoorberghJ_at_Logica.com) wrote:
: Hi,

: The following script

: create table test_user_ref (name varchar2(30),
: userid_ref number,
: constraint fk_userid
: foreign key (userid_ref)
: references SYS.DBA_USERS
: (USER_ID));
: results in:

: ERROR at line 5:
: ORA-02444: Cannot resolve referenced object in referential constraints

: Does anybody have a workaround for this problem?

: Thanx,

: Jeroen
Received on Tue Feb 23 1999 - 22:33:36 CST