Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Using a sequence in a linked database - howto?

Using a sequence in a linked database - howto?

From: Eric <eric_at_salwan.com>
Date: 9 Aug 2001 07:37:42 -0700
Message-ID: <f8cf532.0108090637.45b25f1e@posting.google.com>

Hi.

I have a test and a production database. I would like the test database to access the sequences in the production database for my triggers (so that I can transfer records from test to production without synchronization problems or duplicate primarykey ID's). I created a link to the production database but can figure out how to get the triggers to access the sequences through this link.

Any ideas?

Thanks,

Eric Received on Thu Aug 09 2001 - 09:37:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US