Hello,
I am designing the architecture for our development team. I want to create three environments. A development environment, Testing environment and production environment. Each environment should has it's own DB. So now I am trying to see if using one CDB and three PDBs would help achieving this design.
I believe that all three PDBs must be totally isolated so shouldn't each one of them be installed in a different virtual machine. Is this even possible? Plus the idea of having all the environments DBs in one VM is kinda new to me and somehow scary.
What do you think is the best way to build those environments?
Thanks
Gado