pdb管理

环境:

DB:12C

OS:Centos 7

 

1.数据库启动然后启动所有的pdb

CREATE OR REPLACE NONEDITIONABLE TRIGGER open_all_pdbs
   AFTER STARTUP
   ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'alter pluggable database all open';
END open_all_pdbs;