12c - PDB to Use Global CDB (ROOT) Temporary Tablespace Functionality is Missing
Oracle 12c documentation:
Storage Limits
The optional STORAGE clause of the CREATE PLUGGABLE DATABASE statement specifies the following limits:
-
The amount of storage that can be used by all tablespaces that belong to the PDB
Use MAXSIZE and a size clause to specify a limit, or set MAXSIZE to UNLIMITED to indicate no limit.
-
The amount of storage in the default temporary tablespace shared by all PDBs that can be used by sessions connected to the PDB
Use MAX_SHARED_TEMP_SIZE and a size clause to specify a limit, or set MAX_SHARED_TEMP_SIZE to UNLIMITED to indicate no limit.
Although it supposed to be the option to have a PDB with no TEMP tablespace that uses the CDB TEMP tablespace, currently this option is not implemented.
Available on MOS ID 2004595.1
No comments:
Post a Comment