Open all Oracle pluggable databases within a container database with a trigger on the container database as follows:

create or replace trigger sys.after_startup
   after startup on database
begin
   execute immediate 'alter pluggable database all open';
end after_startup;
/

Leave a Comment

Scroll to Top