SQL & PL/SQL

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!

Referencing an record from another database

liangtehDec 22 2009 — edited Dec 26 2009

Hi gurus,

I am a novice designing database which referencing between 2 databases use by 2 different applications. I am required to store the primary key of database_a.table_a into database_b.table_b.

I have chosen the primary keys of those table which required to be reference from database b tables as guid.

Please advise am I doing the right way of designing for such scenario ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2010

Added on Dec 22 2009

9 comments

1,228 views