My Oracle Support Banner

Internal Database Limits on Number of Objects, Constraints, and Users (Doc ID 2660231.1)

Last updated on JUNE 10, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

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
However, due to internal limits imposed by datatypes, the number of constraints and tables that can be created in a database are not really unlimited.



Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.