Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Constraints From another schema

PrafullaAug 29 2011 — edited Aug 29 2011
Hi Guys,

I have a table referral_contacts which has a column customer_id.This col is coming from a synonym whose base table is in another schema.
So the current requirement is to establish the referential constratint from that table .I think there is no way to add constraint from a synonym whose base table is in another schema.Is there any method to achieve this without crating the same table .

Any suggestions,coments are highly appreciated.

Thanks,
Prafulla
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2011
Added on Aug 29 2011
#from, #general-database-discussions, #schema
2 comments
524 views