Home > IT Answers > Oracle > Oracle foreign key problem with different schema
Webtechsolutions
55 pts.
 Oracle foreign key problem with different schema
Oracle, Oracle foreign keys
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
RELATED QUESTIONS
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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Webtechsolutions, there is no question here.

Are you having problems ? what problems ?

carlosdl
 63,535 pts.