How to change the open mode of all pluggable databases

(Marco V.) When you need to modify the open mode of all your PDBs at the same time (look at this post if you want to change the open mode of only a specific pluggable database) you can use ALTER PLUGGABLE DATABASE command and the ALL option.

Read More - Register for Free Membership