Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Unanswered: Reset a Sequence

    Hi guys,

    I have a sequence in place on my 9i database which is under construction. However, the sequence always starts up from the last place it left off. Ie, if I drop the sequence and load it again later, it continues from where it was rather than returning to the starting point.

    Is there any way to reset the sequence if I drop it?

  2. #2
    Join Date
    Nov 2005
    Posts
    3
    Sorry, Ignore this - I was having a stupid moment

    Admin/Moderator, please feel free to remove this thread.

    My apologies

  3. #3
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    Can you post a piece of code where you drop and recreate your sequence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •