Oracle foreign key problem with different schema
Reference when object not exist in same schema.

Software/Hardware used:
oracle
ASKED: August 21, 2009  3:34 AM
UPDATED: August 21, 2009  2:32 PM

Answer Wiki:
Use system username for this grant Conn system/<password>@hostname; grant references on ERP_CENTERAL.CHANNEL_PARTNER_CATEGORY to public; ALTER TABLE ERP_SUMMARY.TERRITORY ADD CONSTRAINT FK_TERRITORY_CATEGORY FOREIGN KEY (CATEGORY) REFERENCES ERP_CENTERAL.CHANNEL_PARTNER_CATEGORY(CATEGORY);
Last Wiki Answer Submitted:  August 21, 2009  3:34 am  by  Webtechsolutions   55 pts.
All Answer Wiki Contributors:  Webtechsolutions   55 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Webtechsolutions, there is no question here.

Are you having problems ? what problems ?

 63,535 pts.