import sequence

[shenru]

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?

[pando]

find maximum PK and create a sequence starting from that value + 1

[pnrdba]

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

[shenru]

Hi, guys, I found another way is to increment the sequence current number. Quite stupid way ah.

[pando]

well how do you increase a sequence number if you have not imported that sequence?

you still have to create it huh