Microsoft Windows [版本 10.0.17763.1339]
(c) 2018 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>sqlplus sys/sys as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 星期二 12月 19 13:50:45 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
连接到:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter session set container=CDB$ROOT;
会话已更改。
SQL> create pluggable database CSpdb admin user ftoais identified by 1 roles=(connect) file_name_convert=('E:\app\Administrator\oradata\ORCL\pdbseed','E:\app\Administrator\oradata\ORCL\CSpdb');
插接式数据库已创建。
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 FTOAISPDB READ WRITE NO
5 RDPDB READ WRITE NO
6 PDB1 MOUNTED
7 CSPDB MOUNTED
SQL> alter pluggable database CSPDB open;
插接式数据库已变更。
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 FTOAISPDB READ WRITE NO
5 RDPDB READ WRITE NO
6 PDB1 MOUNTED
7 CSPDB READ WRITE NO
SQL> alter session set container=CSPDB;
会话已更改。
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
SQL> alter pluggable database close immediate;
插接式数据库已变更。
SQL> alter pluggable database open read write restricted;
插接式数据库已变更。
SQL> alter session set container=CSPDB;
会话已更改。
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
SQL> alter database character set internal_use ZHS16GBK;
数据库已更改。
SQL> alter pluggable database CSPDB close;
插接式数据库已变更。
SQL> alter pluggable database CSPDB open;
插接式数据库已变更。
SQL> alter session set container=CSPDB;
会话已更改。
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
SQL> alter session set container=cdb$root;
会话已更改。
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
SQL>