"Tilwen" <tilwenbr_at_netscape.net> wrote in message
news:8a41a7df.0208291225.540b9e54_at_posting.google.com...
> I've done this before and have looked in the archives and really
> didn't get the answer I was looking for. I did a user export from
> database A and then did a fromuser to user import to database B. I
> also dropped this user and recreted it. After the data was imported,
> we started getting a primary key constraints from the sequences. You
> probably know the question and answer; however, I've done this before
> and haven't had any problems. At least no one has told me so. I have
> read in the archives that the sequences are seperate from other
> objects, which makes perfectly sense. My question is, do the sequences
> start completely over, or start with the last number that was imported
> from the database a. It acts like that it starts over from one. Then
> in reality, it wasn't done right before. :) . I'm still learning. :)
>
> Mike
>
If you drop the sequences before running the import, then they will be
imported with the values they had at the time of the export. My guess is you
had not dropped all the sequences before running the import.
Received on Thu Aug 29 2002 - 17:09:26 CDT
