Last active
May 8, 2017 03:29
-
-
Save DarkAngelStrike/edd232121ea87fd1074376b8e1e233ea to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SYS@CDB> alter session set container = CDB$ROOT; | |
Session altered. | |
SYS@CDB> show con_name | |
CON_NAME | |
------------------------------ | |
CDB$ROOT | |
SYS@CDB> show pdbs | |
CON_ID CON_NAME OPEN MODE RESTRICTED | |
---------- ------------------------------ ---------- ---------- | |
2 PDB$SEED READ ONLY NO | |
4 PDB READ WRITE NO | |
SYS@CDB> col username for a30 | |
SYS@CDB> select username, common, con_id from cdb_users where username like 'APEX%'; | |
USERNAME COMMON CON_ID | |
------------------------------ ------ ---------- | |
APEX_LISTENER NO 4 | |
APEX_PUBLIC_USER YES 4 | |
APEX_REST_PUBLIC_USER NO 4 | |
APEX_050000 YES 4 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment