ORA-65114: space usage in container is too high

While an import for a pluggable database and it ran out of space so I tried to resize one of the datafile and got below error while doing it :-

SQL> ALTER DATABASE DATAFILE ‘/u02/PROD/ORADATA/User01.dbf’ RESIZE 10g;
ALTER DATABASE DATAFILE ‘/u02/PROD/ORADATA/User01.dbf’ RESIZE 10g
*
ERROR at line 1:

Cause :-

This error generally comes when total size of PDB after resize of the datafile is more than the size you have allocated to a PDB while creating.

Solution :-

Change the allocation storage for a PDB and then try to resize the datafile.

Allocation storage of a PDB can be changed by logging in to the PDB :-

SQL> alter session set container=PROD;

Session altered.

Either change the allocation storage to a required value or change it to unlimited.

SQL> ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;

Pluggable database altered.

Velmurugan Ramasubbu