Re: Problem importing sequences
From: Steven Pilgrim <steve_at_llap.demon.co.uk>
Date: 1996/02/18
Message-ID: <824676354.14336_at_llap.demon.co.uk>#1/1
Date: 1996/02/18
Message-ID: <824676354.14336_at_llap.demon.co.uk>#1/1
markp10013_at_aol.com (MarkP10013) wrote:
>Here's my problem: I'am trying to copy a database from one machine to
>another by first exporting from the source machine at the user level and
>then importing on the target machine at the same user level. Everything
>goes well. (import successful with warnings) The row counts are the same,
>but the sequences are not updated. What could be causing this to happen?
Mark,
Have you copied the database more than once? You would need to delete
from the tables and drop the sequences. The import will then re-create
them. In the import file sequence are a bunch of "create sequence"
statements, they do not update existing ones.
regards,
Steve
Received on Sun Feb 18 1996 - 00:00:00 CET