Maximum data capacity limits for Oracle databases and maximum data capacity limits for table spaces
Reference text:
What's the Maximum tablespace Size and Database Limit for a Oracle database? (Doc ID 1372905.1)
Suitable for:
Oracle database-enterprise edition-version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Oracle database-enterprise edition-version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Goal:
What is the maximum value in Oracle 10g and 11g?
Database
Tablespace
DataFile
Workaround:
For small file database
For a small file database, the Oracle database has the following limits:
Maximum number of datafiles is:65533
Maximum data blocks per datafile:2^22-1 = 4194303
Maximum datafile size = Db_block_size * Maximum number of blocks
Maximum db_block_size = K
Maximum tablespace size = 1022 * Max database file
Resulting values are:
Maximum datafile size = * 4194303 = GB
Maximum tablespace size = 1022 * GB = 130816 GB
Maximum database size = G * 65533 = 8388224 GB
For big file database
For a big file database, the Oracle database has the following limits:
Maximum number of datafiles is:65533
Maximum data blocks per datafile:2^32 = 4294967296
Maximum datafile size = Db_block_size * Maximum number of blocks
Max db_block_size = K
Maximum tablespace size = size of big datafile
Resulting values are:
Maximum datafile size = * 4294967296 = TB
Maximum tablespace size = TB
Maximum database size = T * 65533 =8388224 TB