间的管理和CDB一样，只需要切换到正确的container即可。

SQL> select name,open_mode from v$pdbs;



NAME OPEN_MODE

------------------------------ ----------

PDB$SEED READ ONLY

PDBCNDBA READ WRITE

PCNDBA2 READ WRITE



SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT



SQL> alter session setcontainer=pcndba2;

Session altered.



SQL> show con_name

CON_NAME

------------------------------

PCNDBA2





SQL> col tablespace_name for a15

SQL> col file_name for a60

SQL> selecttablespace_name,file_id,file_name from dba_data_files;



TABLESPACE_NAME FILE_ID FILE_NAME

--------------- ----------------------------------------------------------------------

SYSTEM 12/u01/app/oracle/oradata/cndba/pcndba2/system01.dbf

SYSAUX 13 /u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbf

USERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf



SQL> CREATE TABLESPACE dave

2 DATAFILE'/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf' SIZE 1M

3 AUTOEXTEND ON NEXT 1M;

Tablespace created.



SQL> ALTER TABLESPACE dave ADD

2 DATAFILE'/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbf' SIZE 1M

3 AUTOEXTEND ON NEXT 1M;



Tablespace altered.



SQL> selecttablespace_name,file_id,file_name from dba_data_files;



TABLESPACE_NAME FILE_ID FILE_NAME

--------------- ----------------------------------------------------------------------

SYSAUX 13/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbf

SYSTEM 12 /u01/app/oracle/oradata/cndba/pcndba2/system01.dbf

USERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf

DAVE 17/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf

DAVE 18/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbf



SQL> DROP TABLESPACE dave INCLUDINGCONTENTS AND DATAFILES;

Tablespace dropped.



SQL> selecttablespace_name,file_id,file_name from dba_data_files;

TABLESPACE_NAME FILE_ID FILE_NAME

--------------- ----------------------------------------------------------------------

SYSTEM 12/u01/app/oracle/oradata/cndba/pcndba2/system01.dbf

SYSAUX 13/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbf

USERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf

3 Undo 表空间

CDB中的undo 表空间只能从CDB中管理，不能从non-CDB中管理。

PDB 没有自己的undo 表空间，PDB 中直接使用CDB中的undo 表空间。

如果连上PDB，是看不到undo 表空间的。

SQL> show con_name



CON_NAME

------------------------------

PCNDBA2

SQL> select tablespace_name fromdba_tablespaces;



TABLESPACE_NAME

---------------

SYSTEM

SYSAUX

TEMP

USERS





--切换到CDB中：

SQL> alter session setcontainer=CDB$ROOT;

Session altered.



SQL> show con_name



CON_NAME

------------------------------

CDB$ROOT



SQL> select tablespace_name fromdba_tablespaces;



TABLESPACE_NAME

---------------

SYSTEM

SYSAUX

UNDOTBS1

TEMP

USERS



SQL> select name from v$datafile;



NAME

----------------------------------------------------------------------

/u01/app/oracle/oradata/cndba/system01.dbf

/u01/app/oracle/oradata/cndba/sys

Oracle12cCDB和PDB表空间管理和配置说明(二)

3 Undo 表空间