19c cdb

在Oracle19C中，账号分为两种，一种是公用账号，一种是本地账号。共有账号是指在CDB下创建，并在全部PDB中生效的账号，另一种是在PDB中创建的账号

cdb下创建账户

create user C##ncc identified by ncc;

查看监听

Services Summary...
Service "1825dd9f6e0a1c68e063e114a8c07b4c" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "ora19c" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...

sqlplus cdb登录

sqlplus  C##ncc/[email protected]:1521/orcl

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT

create table tt (n varchar2(100));

查看对象

SQL> select a.owner,a.segment_name from dba_segments a where a.segment_name='TT';

OWNER            SEGMENT_NAME
-------------------- --------------------
C##NCC            TT

cdb账户登录到pdb

SQL> alter session set container=ORA19C;

Session altered.

SQL> grant dba to C##ncc;

sqlplus  C##ncc/[email protected]:1521/ora19c

pdb下创建用户

alter session set container=ORA19C;

create user ncc identified by ncc;

sqlplus pdb登录

sqlplus ncc/[email protected]:1521/ora19c

SQL> show con_name;

CON_NAME
------------------------------
ORA19C

create table tt (n varchar2(100));

查看对象

SQL> set lines 200
SQL> col owner for a20
SQL> col SEGMENT_NAME for a20
SQL> select a.owner,a.segment_name from dba_segments a where a.segment_name='TT';

OWNER           SEGMENT_NAME
-------------------- --------------------
SYS                  TT