Monday, May 4, 2015

12c - Change PDB global name

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 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