Hi All,
I'm just doing a bit of self study on CDBs (no current plans to use this for
real) and can't understand why, when connected to CDB$ROOT as SYS I can count
the users in CDB_USERS but can't select them. I'm not sure if this is a bug
or, being new to all this, I'm just not understanding the concept properly.
I'd appreciate any enlightenment! (Please see my sqlplus spool below)
Many thanks,Charlotte
SQL> select version from v$instance; VERSION-----------------12.1.0.1.0 SQL>
show userUSER is "SYS"SQL> show con_id CON_ID------------------------------1
SQL> select con_id,open_mode from v$pdbs; CON_ID OPEN_MODE----------
---------- 2 READ ONLY 3 READWRITE 4 READWRITE
5 READWRITE 6 READWRITE SQL> select count(*) from cdb_users where
con_id=4; COUNT(*)---------- 44 SQL> select * from cdb_users where
con_id=4; no rows selected