By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,153 Members | 1,744 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,153 IT Pros & Developers. It's quick & easy.

Sequences cache change

P: 1
Hello, I have to change cache for all sequences in schema and database.I can not change one by one.My question, is there some script or query which can change cache size for all sequences ??Please help me.

Best regards
May 29 '19 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
Can you explain why you are attempting this?
Sequences are normally one-direction counters alot like the autonumber field in and Access database or the Auto_Increment in MySQL databases

There is a way to set the sequence to a given value but I don't think it's usually advisable

With that said, you might find the following helpful:
Jun 5 '19 #2

Post your reply

Sign in to post your reply or Sign up for a free account.