Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

obj# from sys.obj$ reaches maximum value of 4Billion

Mohamed HouriJan 30 2024

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

Comments
Post Details
Added on Jan 30 2024
11 comments
177 views