creating bigfile tablespace with maxsize 32T fails with ORA-00740
(Doc ID 3049945.1)
Last updated on SEPTEMBER 30, 2024
Applies to:
Gen 2 Exadata Cloud at Customer - Version N/A and laterInformation in this document applies to any platform.
Symptoms
The manual says the maximum size of a bigfile tablespace is 32 TB.
ref)
----------------------------------------
https://docs.oracle.com/en/database/oracle/oracle-database/23/refrn/physical-database-limits.html#GUID-939CB455-783E-458A-A2E8-81172B990FE9
A.2 Physical Database Limits
Bigfile Tablespaces
Number of blocks
A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion ( 232 ) blocks.
The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks.
----------------------------------------
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |