Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Pluggable database open trigger.md

Created September 23, 2022 17:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Tracnac/a48bb1ca990c6619c8c398f6555d310c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Tracnac/a48bb1ca990c6619c8c398f6555d310c to your computer and use it in GitHub Desktop.
Download ZIP
Pluggable database open trigger #oracle
Raw
Pluggable database open trigger.md 
CREATE OR REPLACE TRIGGER open_pdbs
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';
END open_pdbs;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment