DBA_USERS is view and you cannot reference on it. Try to reference on
SYS.USER$ table, but it
contains a lot of low-level information. See also description of DBA_USERS
view.
news.logica.com wrote <7au6ud$i4c_at_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 - 12:23:27 CST
