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:
ORA-65114: space usage in container is too high
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.
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;
Either change the allocation storage to a required value or change it to unlimited.
SQL> ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;
Pluggable database altered.