Monday, May 4, 2015
12c - PDB to Use Global CDB (ROOT) Temporary Tablespace Functionality is Missing
Oracle 12c documentation:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13556
Storage Limits
The optionalSTORAGE
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
UseMAXSIZE
and a size clause to specify a limit, or setMAXSIZE
toUNLIMITED
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
UseMAX_SHARED_TEMP_SIZE
and a size clause to specify a limit, or setMAX_SHARED_TEMP_SIZE
toUNLIMITED
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
Subscribe to:
Posts (Atom)