Has anyone ever encountered the situation where the object_id of dba_object (or obj# of sys.obj$) has reached the maximum value allowed : 4,294,967,296
SQL> select power(2,32) max_val from dual;
MAX_VAL
----------
4294967296
I'm referring to the following column:
SQL> select max(object_id) from dba_objects;
MAX(OBJECT_ID)
--------------
80029
SQL> select max(obj#) from sys.obj$;
MAX(OBJ#)
----------
80029
Thanks
Mohamed Houri