Reference to remote database

718837

Is there any way to create foreign key for a table where primary key is in remote database??
Remote database is linked with local database?

Thanks in advance!!

689098

Hi,

Actually, not. You must create a trigger (before insert,update,delete) to maintain a referential constraint.

Regards,

Thiago Hyppolito

689098

Hi,

Actually, not. You must create a trigger (before insert,update,delete) to maintain a referential constraint.

Regards,

Thiago Hyppolito

vasu77

Hi,

You must be using the dblinks. are you?

Rgds

718837

Yes am using dblinks.
With trigger we can make the reference.