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