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
Best regards
-
-
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:
Last edited by zmbd; Jun 5 '19, 01:19 AM.
Comment