Internal Database Limits on Number of Objects, Constraints, and Users
(Doc ID 2660231.1)
Last updated on MAY 01, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
The Oracle RDBMS has some internally imposed limits due to datatypes used. These limits affect the number of objects that can be created, the number of lightweight jobs that can be created, the number of table constraints that can be created, and the number of users that can be created. This note is designed to document these limits and potential workarounds / solutions if they are reached.
In Appendix A of the Oracle Database Reference, the section entitled 'Logical Database Limits' has the following, among others:
|Item||Type of Limit||Limit Value|
|Constraints||Maximum per column||Unlimited|
|Users and Roles||Maximum||2,147,483,638|
|Tables||Maximum per database||Unlimited|
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document