Forum Stats

  • 3,824,847 Users
  • 2,260,430 Discussions


"alter PDB <name> open;" Instead of "alter PLUGGABLE DATABASE <name> open;"

Matheus Boesing
Matheus Boesing Member Posts: 46 Blue Ribbon
edited Feb 3, 2020 3:48PM in Database Ideas - Ideas

Why do we have to type  PLUGGABLE DATABASE every single time?

I'd suggest implementing "pdb" acronym for all syntaxes where we actually need to type "pluggable database", as this is nor practical and time-consuming.

Please make our life easier

10 votes

Active · Last Updated


  • Sven W.
    Sven W. Member Posts: 10,535 Gold Crown

    The normal command is

    For me it makes sense to refer to a PDB by adding the PLUGGABLE in front of the command.

    How often do you type this so that you find, it makes life easier?

  • JesusBM-Oracle
    JesusBM-Oracle Member Posts: 22 Employee

    Hi @Matheus Boesing,

    In my opinion, using full "PLUGGABLE DATABASE" keywords make more sense, especially for historic compatibility with original DDL keyword used for traditional database  - CREATE | ALTER  DATABASE - (or even used in Multinenant Architecture for the Container Database - CDB).

    Just my two cents.

    Best regards,

    Jesus Botello-Mares