oracle²»Í¬schemaÖ®¼ä½¨Íâ¼ü

ÐèҪȨÏÞ:
  grant references on test_sys to user_1;
 or
  grant all on test_sys to user_1;
²âÊÔ£º
sysÓû§ÏÂ:
SQL> create user user_1 identified by user_1;
Óû§ÒÑ´´½¨¡£
SQL> grant dba to user_1;
ÊÚȨ³É¹¦¡£
SQL> create table test_sys(pk_col varchar2(5))
  2  /
±íÒÑ´´½¨¡£
SQL> alter table test_sys modify pk_col primary key;
±íÒѸü¸Ä¡£
user_1Óû§ÏÂ:
 SQL> conn user_1/user_1;
ÒÑÁ¬½Ó¡£
SQL> create table test_fk(fk_col varchar2(5),constraint foreign
  2  key references sys.test_sys(pk_col));
±íÒÑ´´½¨¡£