开云手机站登录入口最新版下载
4个月前 (04-20)
Step1: 切换到相应的PDB下,执行以下命令:
SQL> alter session set container=PDB1;
Session altered.
SQL>Step2 :执行命令来查看:
SQL> select FILE_NAME,FILE_ID,TABLESPACE_NAME from dba_data_files;
FILE_NAME FILE_ID TABLESPACE_NAME
-------------------------------------------------- ---------- ------------------------------
/u02/oradata/CDB1/pdb1/system01.dbf 9 SYSTEM
/u02/oradata/CDB1/pdb1/sysaux01.dbf 10 SYSAUX
/u02/oradata/CDB1/pdb1/undotbs01.dbf 11 UNDOTBS1
/u02/oradata/CDB1/pdb1/users01.dbf 12 USERS
SQL>注意: 对于容器id(con_id)可以通过v$pdbs视图或show pdbs命令进行查看。 同题参见
单实例文件系统
SQL>
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string /u02/oradata
SQL> - CDB root
SQL>
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------
/u02/oradata/CDB1/system01.dbf
/u02/oradata/CDB1/sysaux01.dbf
/u02/oradata/CDB1/undotbs01.dbf
/u02/oradata/CDB1/users01.dbf
SQL> - PDB
SQL>
SQL> alter session set container=PDB1;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB1 READ WRITE NO
SQL> show con_name;
CON_NAME
------------------------------
PDB1
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------
/u02/oradata/CDB1/pdb1/system01.dbf
/u02/oradata/CDB1/pdb1/sysaux01.dbf
/u02/oradata/CDB1/pdb1/undotbs01.dbf
/u02/oradata/CDB1/pdb1/users01.dbf
SQL>分享给朋友: