October 6, 2024
Oracle 23ai Database : BIGFILE Default for SYSAUX, SYSTEM, and USER Tablespaces
oracle 23ai databaseIn ORACLE 23ai Database, BIGFILE is the default for most tablespaces, excluding TEMP. Verification shows SYSAUX, SYSTEM, and USERS having BIGFILE enabled. In pluggable databases like ptmpdb, USERS is not BIGFILE by default. Creating a user-defined tablespace, such as ptmtbs, also defaults to BIGFILE using OMF for location management.