oracle中两个不同用户数据库中的表是否可以建立外键关系?
权限问题
–表授权给另一个用户
grant references on ERP.customer_info to saas;
–添加外键约束
alter table SERVICE_ORDER
add foreign key (CUSTOMER_ID)
references ERP.customer_info (CUSTOMER_ID);
oracle中两个不同用户数据库中的表是否可以建立外键关系?
权限问题
–表授权给另一个用户
grant references on ERP.customer_info to saas;
–添加外键约束
alter table SERVICE_ORDER
add foreign key (CUSTOMER_ID)
references ERP.customer_info (CUSTOMER_ID);