CTAS建表时报错ORA-65114

SQL> 
create table T1 as select * from v$active_session_history
                                 *
ERROR at line 1:
ORA-65114: space usage in container is too high

SQL> !oerr ora 65114
65114, 00000, "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.
//

--PDB中查询：
select property_value from database_properties where property_name = 'MAX_PDB_STORAGE';
--CDB中查询：
select property_name, property_value, description, con_id from cdb_properties where property_name = 'MAX_PDB_STORAGE';

SQL> col PROPERTY_NAME for a22
SQL> col PROPERTY_VALUE for a22
SQL> col DESCRIPTION for a66
SQL> select property_name, property_value, description, con_id from cdb_properties where property_name = 'MAX_PDB_STORAGE';

PROPERTY_NAME          PROPERTY_VALUE         DESCRIPTION                                                            CON_ID
---------------------- ---------------------- ------------------------------------------------------------------ ----------
MAX_PDB_STORAGE        2147483648             Maximum Space Usage of Datafiles and Local Tempfiles in Container           6
MAX_PDB_STORAGE        UNLIMITED              Maximum Space Usage of Datafiles and Local Tempfiles in Container           3
MAX_PDB_STORAGE        UNLIMITED              Maximum Space Usage of Datafiles and Local Tempfiles in Container           4

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         6 AWR                            READ WRITE NO

SQL> alter session set container=awr;

Session altered.

SQL> select sum(bytes/1024/1024/1024) from dba_data_files;

SUM(BYTES/1024/1024/1024)
-------------------------
               2.08984375

SQL> select sum(bytes) from dba_data_files;

SUM(BYTES)
----------
2243952640

CREATE PLUGGABLE DATABASE awr
  ADMIN USER awr IDENTIFIED BY awr
  ROLES = (dba)
  DEFAULT TABLESPACE tbs_awr
    DATAFILE '/flash/oradata/DEMO/awr/awr01.dbf' SIZE 250M AUTOEXTEND ON maxsize 10G	<--- 这里限制该数据文件上限大小10G
  FILE_NAME_CONVERT = ('/flash/oradata/DEMO/pdbseed/',
                       '/flash/oradata/DEMO/awr/')
  STORAGE (MAXSIZE 2G)						<--- 这里限制了总大小2G，额。。
  PATH_PREFIX = '/flash/oradata/DEMO/awr/';

ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 5G);