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