查看PDB名称和状态
SQL> alter session set container=CDB$ROOT;
SQL> show pdbs
SQL> alter session set container=BPXTEST1PDB;
SQL> show pdbs
SQL> show con_name
SQL> select name from v$pdbs;
SQL> select open_mode from v$pdbs;
SQL> select * from v$pdbs;
SQL> desc v$pdbs
查看PDB表空间的数据表信息
SQL> select tablespace_name from dba_data_files;
查看PDB数据库默认创建的表空间
SQL> select tablespace_name,status,contents from dba_tablespaces;
查看默认创建的表空间对应的数据文件
SQL> select name from v$datafile;