Search This Blog

Wednesday, September 9, 2020

Oraclre 12C: Pluggable Database (PDB) Automatic Startup

Below trigger will be created after SYS login to Container database



CREATE OR REPLACE TRIGGER auto_open_pdb

  AFTER STARTUP ON DATABASE 

BEGIN 

   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 

END auto_open_pdb