-
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
PNRDBA
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|