oracle查看pdb表空间,管理与使用PDB的表空间

1、进入PDB，打开PDB，显示连接名称

SQL> alter session set container=orclpdb;

Session altered.

SQL> show con_name;

CON_NAME

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

ORCLPDB

2、查看PDB中对象的名称

SQL> select name,open_mode from v$pdbs;

NAME OPEN_MODE

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

ORCLPDB READ WRITE

3、查看PDB表空间的数据表信息

SQL> select tablespace_name,file_id,file_name from dba_data_files;

TABLESPACE_NAME FILE_ID FILE_NAME

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

SYSTEM ########## /u01/app/oracle/oradata/cnbugs/orclpdb/s

ystem01.dbf

SYSAUX ########## /u01/app/oracle/oradata/cnbugs/orclpdb/s

ysaux01.dbf

UNDOTBS1 ########## /u01/app/oracle/oradata/cnbugs/orclpdb/u

ndotbs01.dbf

USERS ########## /u01/app/oracle/oradata/cnbugs/orclpdb/u

sers01.dbf

TABLESPACE_NAME FILE_ID FILE_NAME

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

4、查看PDB数据库默认创建的表空间

SQL> select tablespace_name,status,contents from dba_tablespaces;

TABLESPACE_NAME STATUS CONTENTS

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

SYSTEM ONLINE PERMANENT

SYSAUX ONLINE PERMANENT

UNDOTBS1 ONLINE UNDO

TEMP ONLINE TEMPORARY

USERS ONLINE PERMANENT

5、查看默认创建的表空间对应的数据文件

SQL> select name from v$datafile;

NAME

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

/u01/app/oracle/oradata/cnbugs/orclpdb/system01.dbf

/u01/app/oracle/oradata/cnbugs/orclpdb/sysaux01.dbf

/u01/app/oracle/oradata/cnbugs/orclpdb/undotbs01.dbf

/u01/app/oracle/oradata/cnbugs/orclpdb/users01.dbf

6、查看HR用户的所有数据表的信息

SQL> select owner,table_name,tablespace_name,status from dba_tables where owner='HR';

7、查看EXAMPLE表空间中隶属于HR用户的数据表departments的结构数据和记录数据

desc hr.departments;

8、关闭PDB进入CDB

SQL> alter pluggable database close immediate;

Pluggable database altered.

SQL> alter session set container=cdb$root;

Session altered.

SQL> show con_name;

CON_NAME

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

CDB$ROOT