I was creating tablespace in a newly created PDB and was facing " ORA-65114: space usage in the container is too high "
ORA-65114: space usage in the container is too high
So it happens when you created PDB with a storage option less than you need. Below is the example, I used to create PDB:
create pluggable database TEST admin user admin identified by "oracle" default tablespace USERS
datafile '/u02/oradata/TEST/pdb1_users01.dbf' size 250m autoextend on
storage (maxsize 1g max_shared_temp_size 1g)
file_name_convert=('/u02/oradata/TEST/datafile/','/u02/oradata/TEST/TEST');
Want to know drawback of oracle ? check this
This mean oracle will not go beyond 1G. As I used MAX to 1G and below is the error.
Below is the error:-
SQL> CREATE TABLESPACE "TEST" LOGGING DATAFILE '/u02/oradata/TEST.DBF' SIZE 750M AUTOEXTEND ON NEXT 8M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "TEST" LOGGING DATAFILE '/u02/oradata/TEST.DBF' SIZE 750M AUTOEXTEND ON NEXT 8M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
*
ERROR at line 1:
ORA-65114: space usage in container is too high
Solution:-
Just increase the storage limit of the pluggable database. Run the following SQL in the current PDB to limit the size of all datafiles of that PDB:
SQL> ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;
Pluggable database altered.
OR if you want a limited SIZE, You can still define the size.
SQL> alter pluggable database storage (MAXSIZE 120G);
Note:- If not defined storage option by default of MAX_PDB_STORAGE is no limit.
How to check the max size of PLUGGABLE DATABASE STORAGE?
To check value in current PDB, Conenct to PDB and run below :
select PROPERTY_VALUE FROM database_properties WHERE property_name = 'MAX_PDB_STORAGE';
To check value in current CDB for all PDB'S, Conenct to CDB and run below :
select PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION,CON_ID FROM cdb_properties WHERE property_name = 'MAX_PDB_STORAGE';
