Referencing SYS.DBA_USERS ???

From: news.logica.com <GoorberghJ_at_Logica.com>
Date: Tue, 23 Feb 1999 13:32:11 +0100
Message-ID: <7au74l$i93@romeo.logica.co.uk>

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 - 06:32:11 CST