Can you verify the version of sqlplus you are using?
Seth Miller
On Thu, Feb 18, 2016 at 12:35 PM, Charlotte Hammond <
dmarc-noreply@xxxxxxxxxxxxx> wrote:
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 user
USER 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 READ WRITE
4 READ WRITE
5 READ WRITE
6 READ WRITE
SQL> select count(*) from cdb_users where con_id=4;
COUNT(*)
----------
44
SQL> select * from cdb_users where con_id=4;
no rows selected
