Re: Using a sequence in a linked database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 9 Aug 2001 21:48:23 +0200
Message-ID: <997386514.27039.0.pluto.d4ee154e@news.demon.nl>

"Eric" <eric_at_salwan.com> wrote in message news:f8cf532.0108090637.45b25f1e_at_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

Just use <sequencename>@<databaselink>

Most likely it will be SLOOOWW

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 09 2001 - 14:48:23 CDT

Re: Using a sequence in a linked database - howto?