Hi Oracle experts,
As We all know from 12.2 there will be only CDB/PDB architecture, non-CDB will gone forever. I've some doubts about CDB/PDB architecture and I'm looking for some clarification. Right now I'm thinking only about hypothetical what if scenarios.
Let say that I don't have multitenant option. Right now in 12.1 i can have multiple non-CDB instances on single server, exactly as it was in good old pre CDB architecture days. From 12.2 only possibility for me will be single tenant CDB with one PDB, and if I want to have multiple instances on single server I will have to create multiple single tenant CDB, each with only one PDB. I find that unnecessary complication for my environment. Eg. right now I've 10 independent database instances on single server, and with single tenant CDB/PDB I will have 10 CDB's + 10 PDB (not to mention 10 seed db)
My question is ... Do I have to create PDB at all? Can I put all application data only into CDB's? If I can ... how bad is that approach? What bad can happen? If I do so, how in future I can migrate that data to PDB?
Regards