OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Constraint Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Constraint Problem [message #50803]

Mon, 08 April 2002 22:50

kothari Alpesh
Messages: 27
Registered: December 2001

Junior Member

I have two database named prod1 and prod2 on diff. machine.In prod1 DB i have one table named Deptmst with dept_cd primary key. and In prod2 I have one table named budgetmst with dept_cd and i want to create foreign key between this two tables.
Can I able to create it??
if yes then How??

Report message to a moderator

Re: Constraint Problem [message #50804 is a reply to message #50803]

Mon, 08 April 2002 23:05

Shrikanth
Messages: 16
Registered: April 2002

Junior Member

hi
you can do it using database link. create a database from one database to another and alter the table and add the constraint to it

Report message to a moderator

Re: Constraint Problem [message #50808 is a reply to message #50803]

Tue, 09 April 2002 00:44

kothari Alpesh
Messages: 27
Registered: December 2001

Junior Member

alter table alps add constraint alps_no_pk foreign key(no)
references hempmsthdr@hrd.world(emp_cd);

It will give error like
ORA-02021: DDL operations are not allowed on a remote database

Report message to a moderator

Re: Constraint Problem [message #50846 is a reply to message #50803]

Wed, 10 April 2002 23:05

Alpesh Kothari
Messages: 7
Registered: April 2002

Junior Member

Hi shrikanth,
Thanx for the suggestion but it won,t work.
can Pl. able to forward me each step for this

Thanx
Alpesh

Report message to a moderator

Previous Topic:	HOW TO HAVE ONLY ONE LOGIN ATTEMPT while connecting to Oracle
Next Topic:	FSFI- need fast reply

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 13:34:39 CDT 2024