点
上边蓝字
关注我们
alter database character set internal_use
这个命令到底能不能用呢,在oracle database 19c版本中,无论是non_cdb,还是pdb,通过实践来看,还是能用的。
但是!但是!但是!
有谁敢用呢?
non_cdb
SYS@orcl> startup restrictORACLE instance started.SYS@orcl> alter database character set internal_use zhs16gbk; Database altered.SYS@orcl> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SYS@orcl> startupORACLE instance started.SYS@orcl> select userenv('language') from dual;USERENV('LANGUAGE')----------------------------------------------------AMERICAN_AMERICA.ZHS16GBK
pdb
SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1