The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, Prashant.
Asked: February 11, 2020 - 2:19 pm UTC
Last updated: February 14, 2020 - 11:29 am UTC
Version: oracle 10g
Viewed 1000+ times
create sequence s maxvalue 500; select sequence_name, max_value, last_number from user_sequences where ( max_value - last_number ) < 1000; -- or whatever threshold you deem safe SEQUENCE_NAME MAX_VALUE LAST_NUMBER S 500 1 alter sequence s maxvalue 999999999999999999; select sequence_name, max_value, last_number from user_sequences where ( max_value - last_number ) < 1000; no rows selected
Prashant, February 12, 2020 - 8:47 am UTC
A reader, February 14, 2020 - 11:16 am UTC
New to good database design? Check out Chris Saxon's full fundamentals class.