暂无图片
安装oracle后创建用户必须要加C##
我来答
分享
暂无图片 匿名用户
安装oracle后创建用户必须要加C##

安装oracle后创建用户必须要加C##

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
JiekeXu
暂无图片

如下:创建 CDB 用户则需要加 C##,PDB 用户则不需要。

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> SQL> 
SQL> 
SQL> 
SQL> show pdbs 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO

SQL> 
SQL> create user cdb identified by cdb;
create user cdb identified by cdb
            *
ERROR at line 1:
ORA-65096: invalid common user or role name


Elapsed: 00:00:01.49
SQL> create user c##cdb identified by cdb;

User created.

Elapsed: 00:00:11.09
SQL> alter session set container=pdb1;

Session altered.

Elapsed: 00:00:00.02
SQL> create user cdb1 identified by cdb1;

User created.

Elapsed: 00:00:04.76
SQL> show dbs 
SP2-0158: unknown SHOW option "dbs"
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB1                           READ WRITE NO
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏