12c: ORA-65114: space usage in container is too high

ORA-65114: space usage in container is too high

Cause: Space usage in the current container exceeded the value of MAX_PDB_STORAGE for the container.

Action: Specify a higher value for MAX_PDB_STORAGE using the ALTER PLUGGABLE DATABASE statement.

Test:

SQL> show con_name

CON_NAME

------------------------------

PDB2

SQL> create tablespace pdb2TS1 datafile size 10M;

create tablespace pdb2TS1 datafile size 10M

*

ERROR at line 1:

ORA-65114: space usage in container is too high

SQL> select name, TOTAL_SIZE/1024/1024 SIZE_MB from v$pdbs;

NAME                              SIZE_MB

------------------------------ ----------

PDB2                                  860

-- Increase the total storage of the the PDB (datafile and local temp files).

SQL> ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 2048M);

Pluggable database altered.

You could use some other options

-- Limit the amount of temp space used in the shared temp files.

ALTER PLUGGABLE DATABASE STORAGE (MAX_SHARED_TEMP_SIZE 1G);

-- Combine the two.

ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 1G);

-- Remove the limits.

ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;

SQL> select name, TOTAL_SIZE/1024/1024 SIZE_MB from v$pdbs;

NAME                              SIZE_MB

------------------------------ ----------

PDB2                                  860

SQL> create tablespace pdb2TS1 datafile size 10M;

Tablespace created.

SQL> select name, TOTAL_SIZE/1024/1024 SIZE_MB from v$pdbs;

NAME                              SIZE_MB

------------------------------ ----------

PDB2                                  870