I've created a number of PDB's in CBD's that have TDE running. For each PDB created, I have to close the autologin wallet, open it with the keystore password and set the TDE on the PDB. This has heretofore been done through SQL-Plus. However if I use OEM and create the PDB using the "wizard driven" options in it, it will create the PDB with TDE from the outset and no need to go through the ritual with the autologin. This has got me thinking: is it not possible to do the same when creating the PDB through SQL Plus?
My SQL create PDB statement is simple as follows:
CREATE PLUGGABLE DATABASE my_pdb_name ADMIN USER ms_pdb_admin_user IDENTIFIED BY my_pdb_user_pwd;
Could I vary the above to create the PDB with TDE (i.e. specify the TDE password) and if so, how should I do this?