OBJ$

Reuse Object IDs in Oracle Database 19c and 23ai

I love to learn something new every day. And thanks to my Dutch friend, Robert Pastijn, I learned about a limitation of how many objects you can create in an Oracle database. Nothing to worry about, the limit is very high at a little bit over 4.2 billion. But in order to prevent hitting it, we introduced a mechanism to Reuse Object IDs in Oracle Database 19c and 23ai.

Reuse Object IDs in Oracle Database 19c and 23ai

Photo by Rosie Sun on Unsplash

What is the mechanism?

First of all, this is ON and enabled in Oracle Database 23ai by default. But in case you need this …

Continue reading...