pdf用什么软件打开 pdb是什么文件格式能不能删除( 二 )


3 1930201447 E89E9418B882350CE043DE07A8C092B6 PDBEPPS MOUNTED
5)启动PDB数据库
方式1:
SQL> alter pluggable database PDBEPPS open;
P
Pluggable database altered.
S
SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;
CON_ID DBID GUID NAME OPEN_MODE
———- ———- ——————————– —————————— ———-
2 4071321146 E89E8DA2866E3157E043DE07A8C09238 PDB$SEED READ ONLY
3 1930201447 E89E9418B882350CE043DE07A8C092B6 PDBEPPS READ WRITE
方式2:
SQL> alter session set container=PDBEPPS;
Session altered.
SQL> startup
Pluggable Database opened.
6)关闭PDB数据库
SQL> alter pluggable database PDBEPPS close;
Pluggable database altered.
SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;
CON_ID DBID GUID NAME OPEN_MODE
———- ———- ——————————– —————————— ———-
2 4071321146 E89E8DA2866E3157E043DE07A8C09238 PDB$SEED READ ONLY
3 1930201447 E89E9418B882350CE043DE07A8C092B6 PDBEPPS MOUNTED
SQL>
7)在容器间切换
SQL> alter session set container=PDBEPPS;
Session altered.
SQL> show con_name;
CON_NAME
——————————
PDBEPPS
SQL> alter session set container=CDB$ROOT;
Session altered.
SQL> show con_name;
CON_NAME

推荐阅读