一个库,DBA权限登陆
SQL> alter table S.MX12
2 add constraint FK_S_ZJ foreign key (NSRLXDM, SBBLXDM)
3references D.RLX (NSRLXDM, SBBLXDM);
references D.RLX (NSRLXDM, SBBLXDM)
*
ERROR 位于第 3 行:
ORA-01031: insufficient privileges
另一个库:
SQL> select count(*) from D.RLX;
COUNT(*)
----------
8
SQL> alter table S.MX12
2 add constraint FK_D_ZJ foreign key (NSRLXDM, SBBLXDM)
3references D.RLX (NSRLXDM, SBBLXDM);
references D.RLX (NSRLXDM, SBBLXDM)
*
ERROR 位于第 3 行:
ORA-00942: table or view does not exist
谢谢
|