Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Naming convention for CDBs and PDBs

MaxOct 15 2019 — edited Oct 25 2019

DB version : 19C

OS : OL 7.6/8 (Yet to finalize)

I work for an MNC bank. And all our new DBs will be using multitenant. Well, we are forced to do that

So, I am thinking of naming our CDBs and PDBs like below

CDB : <Business division Name>CDB<ascendingNumber>

PDB : <Business division Name><CDB's number><ApplicationName><Environment (like prod,UAT,SIT)>PDB

For example if the business Division name is FRM and application is TSM and if it is a production DB , and if it is 23rd CDB for this division, I will name it like

CDB : FRMCDB23

PDB : FRM23TSMPRDPDB

What do you guys think of this naming convention ? Is it horrible ? Any comments ?

This post has been answered by BPeaslandDBA on Oct 15 2019

Jump to Answer

Added on Oct 15 2019

#database-key-features, #multitenant

4 comments

6,668 views