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

Thread: sequence number was skipped

Threaded View

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    sequence number was skipped

    some of the user complained that the sequence number that was generated from the application was skipped somehow.

    Does anyone know why it skipped ??? There was nothing in the log file. the cause and solutions for this problems???

    below is the dll of my sequence.

    CREATE SEQUENCE blaw
    INCREMENT BY 1
    START WITH 1000000
    MINVALUE 1
    MAXVALUE 999999999999999999999999999
    NOCYCLE
    NOORDER
    CACHE 20
    /


    thanks
    Last edited by mike2000; 05-05-2003 at 10:22 AM.

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