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

Thread: Sequence got smaller

  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Sequence got smaller

    Hello,
    I'm useing Oracle 10g and I had aproblem with my sequence.
    I have a dot.net application that work with oracle and a field that got a number from the Sequence. a few days ago when every thing got wrong I check and discaver that my Sequence got smaller.

    He was around 10300 one day and became 10100 the next day.

    Any body heared about such a thing?

    Thanks

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    several scenarios...
    ... negative increment.
    ... sequence is set to recycle and already hit max value
    ... sequence got recreated
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2008
    Posts
    3

    If it was only that easy

    The increment is positive,
    Its not even close to the max value so no reason to recycle
    and the only other option (recreated) seems like the only explanation but its a closed DB in the office in a stand alone network with a really small chance of being hack by one of the worker and I am the only one with a password to it :(

    Thats way I Thought maybe there is a knowen bug about that issue.

    Thanks for your reply.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,014
    I'm with Pavb on this, except I would like to offer one more possible solution. The database was abducted by aliens. I'm not saying it must have happened only that it hasn't yet been ruled out.

    Perhaps if you looked at the following two queries the real answer might jump out at you. Specifically look at the dba_objects view, and the created and last ddl columns.

    Code:
     select * 
    from dba_sequences 
    where sequence_owner='SCHEMA'
    order by 1,2;
    Code:
    select * 
    from dba_objects 
    where owner='SCHEMA' 
    and object_type='SEQUENCE' 
    and object_name='SEQUENCENAME';
    this space intentionally left blank

  5. #5
    Join Date
    Aug 2008
    Posts
    3

    Thanks Gandolf

    I can't say that I solved the problem so lets just leave this aliens abduction as a valid option

    Thanks any way for your help, I will continue to investigate into this metter.

    Roy.

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