Can I convert below source database to as target PDB what had different NLS_CHARACTERSET with Target CDB?
Source Instance:
Source Database(non-cdb)
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16
Target Instance:
Target CDB :
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
Target PDB (Migrated Non CDB)
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16
Yes, as long as the CDB is a superset of the PDB characterset then we now support the PDB having differing (ie subset) characterset from the CDB.
I'd be inclined to do a hot clone because then you still have source database intact if something does not work, or you hit a regression , so you'll have something like
CREATE PLUGGABLE DATABASE my_new_pdb FROM old_non_cdb@my_dblink;