Re: Remote sequence
From: Joe Nardone <joe_at_access4.digex.net>
Date: 1996/01/12
Message-ID: <4d6deh$5nf_at_news4.digex.net>#1/1
Date: 1996/01/12
Message-ID: <4d6deh$5nf_at_news4.digex.net>#1/1
Jarle Nerland (jarlen_at_sn.no) wrote:
:
: I am trying to make a copy of a remote database
: into a PO7 database. Copying all the tables works
: fine when using
: CREATE TABLE PERSON
: AS
: SELECT * FROM PERSON_at_REMOTE.
:
: BUT HOW DO I COPY THE SEQUENCE'S IN THE REMOTE??
: DATABASE-
: ie, how do I start/update them with the right CURRVAL.
You need to query against USER_SEQUENCES and create a script to re-create the sequence (the MIN, MAX, INCREMENT BY, and most importantly LAST_NUMBER are all there)...
Joe
:
: Jarle Nerland, Oslo, Norway
: jarlen_at_sn.no
:
:
-- =------------------------------------------------------------------= Joe Nardone <joe_at_access.digex.net> "Now that I have my coffee, I'm ready to watch radar." -----BEGIN PGP PUBLIC KEY BLOCK----- Version: 2.6.2 mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7 pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu bmV0Pg== =1ocE -----END PGP PUBLIC KEY BLOCK-----Received on Fri Jan 12 1996 - 00:00:00 CET