Database Administration (MOSC)

MOSC Banner

Database limits - number of objects

edited Apr 6, 2023 2:05PM in Database Administration (MOSC) 8 commentsAnswered ✓

Hi all,

In docs (Database reference - Logical database limits) we read

Dictionary-managed database objects

Maximum per database

4,254,950,911 - overhead.

In one of our 19c databases application is permanently recreating tables, and object_id is close to max number of objects in oracle database. At the same time total number of existing ibjects in database is not high, maybe 100000.

So what is going to happen when object_id approaches 4254950911?

Does 4254950911 limit number of tables that can exist in an Oracle database or 4254950911 is the max object_id in an Oracle database?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center