Thanks for the question, Stapeevich.
Asked: May 10, 2023 - 1:15 pm UTC
Last updated: May 11, 2023 - 2:29 pm UTC
Version: 19.19
Viewed 1000+ times
You Asked
Good day,
I am testing Oracle 19.19 object_id reuse feature (Doc ID 2923706.1) and need to raise current object_id value to max possible value - 4,254,950,911. I am trying to create/delete objects, but this method is very slow, and I will need months to prepare test environment. Is there a faster way to quickly raise current value of object_id?
Regards
Srjan
and Chris said...
The big question to answer here is:
Why?!
Particularly as it sounds like you're a long way off hitting this limit, what are you hoping to gain by doing this?
If you must go ahead, ultimately you'll have to create lots of objects, which as you say will take a while. To speed this up, run lots of scripts in parallel to create cycle through creating/dropping objects.
Honestly though, I don't see the value in doing this.
Is this answer out of date? If it is, please let us know via a Comment