管理与使用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

Mr丶点心永久会员

打赏 收藏 海报 链接