-
import sequence
Hi, all
I've got one question regarding sequence. Several days ago I imported some tables to a database. However I didn't know that the primary key is generated from a sequence in the database. Since I didn't import sequence, now I have problem creating new records in the tables. System always report unique constraint violated. Do you guys have any idea what I should do? Can I import the sequence as well?
-
find maximum PK and create a sequence starting from that value + 1
-
Thats correct. I implemented in our shop same as the pando said. I moved data from one box to another.
please help me.
thanks in advance
Raju
-
Hi, guys, I found another way is to increment the sequence current number. Quite stupid way ah.
-
well how do you increase a sequence number if you have not imported that sequence?
you still have to create it huh