DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: import sequence

  1. #1
    Join Date
    May 2002
    Posts
    35

    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?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    find maximum PK and create a sequence starting from that value + 1

  3. #3
    Join Date
    Apr 2002
    Posts
    291
    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

  4. #4
    Join Date
    May 2002
    Posts
    35
    Hi, guys, I found another way is to increment the sequence current number. Quite stupid way ah.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width