Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
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.