Written by: ilmarkerm

Category: Blog entry

Published: March 6, 2023

It is possible to use DBMS_SQL to execute dynamic SQL in multiple pluggable databases, from CDB. Oracle does provide CONTAINERS clause, but the use of it is quite limited.

In this example I execute from CDB and I’m stopping all services in all PDB-s, transactionally.