Managing Tablespace in CDB and PDB

0

Managing tablespace in container database is similar to non-container database. Provided you are logged in as a privileged user and point to right container.

Manage Tablespace in CDB

SQL> show con_name
 
CON_NAME
------------------------------
CDB$ROOT
 
SQL> CREATE TABLESPACE CDB_TABLESPACE DATAFILE '+ASM' SIZE 10M AUTOEXTEND ON NEXT 1M;
 
Tablespace created.
 
SQL> ALTER TABLESPACE CDB_TABLESPACE ADD DATAFILE '+ASM' SIZE 10M AUTOEXTEND ON NEXT 1M;
 
Tablespace altered.
 
SQL> select TABLESPACE_NAME, FILE_NAME from cdb_data_files where con_id=1;
 
TABLESPACE_NAME      FILE_NAME
-------------------- ------------------------------------------------------------
SYSTEM               +ASM/CSHARK/DATAFILE/system1
SYSAUX               +ASM/CSHARK/DATAFILE/sysaux1
UNDOTBS1             +ASM/CSHARK/DATAFILE/undotbs1
USERS                +ASM/CSHARK/DATAFILE/users1
CDB_TABLESPACE       +ASM/CSHARK/DATAFILE/cdb_tablespace1
CDB_TABLESPACE       +ASM/CSHARK/DATAFILE/cdb_tablespace2
 
6 rows selected.
 
SQL> DROP TABLESPACE CDB_TABLESPACE INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.

Managing Tablespace in PDB

SQL> show pdbs
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         4 SHARK                          READ WRITE NO
SQL> ALTER SESSION SET CONTAINER=SHARK;
 
Session altered.
 
SQL>
SQL> show con_name
 
CON_NAME
------------------------------
SHARK
 
SQL> CREATE TABLESPACE PDB_TABLESPACE DATAFILE '+ASM' SIZE 10M AUTOEXTEND ON NEXT 1M;
 
Tablespace created.
 
SQL> ALTER TABLESPACE PDB_TABLESPACE ADD DATAFILE '+ASM' SIZE 10M AUTOEXTEND ON NEXT 1M;
 
Tablespace altered.
 
SQL> SELECT TABLESPACE_NAME, FILE_NAME FROM CDB_DATA_FILES WHERE TABLESPACE_NAME='PDB_TABLESPACE';
 
TABLESPACE_NAME      FILE_NAME
-------------------- ------------------------------------------------------------------------------------------
PDB_TABLESPACE       +ASM/CSHARK/ED7B4B/DATAFILE/pdb_tablespace1
PDB_TABLESPACE       +ASM/CSHARK/ED7B3C/DATAFILE/pdb_tablespace2
 
 
SQL> DROP TABLESPACE PDB_TABLESPACE INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.