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

Matheus Boesing

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

Sven W.

The normal command is
ALTER DATABASE OPEN

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

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