描述:
先查询系统有哪些pdb,然后根据pdb的con_id查询特定pdb有哪些新建用户(新建的时间是不同于系统的默认时间20140911)
操作:
C:\Users\v074>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on 星期三 6月 5 09:11:27 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBSKY READ WRITE NO
4 PDBCLOUD READ WRITE NO
5 PDBTEST READ WRITE NO
SQL> select a.name,b.username, b.password,b.created
2