Connecting and querying a container
Hi
Oracle 12c container instance with Plugable
When connecting to the instance with none DBA user and running the query:
SELECT name ,open_mode ,status,TOTAL_SIZE FROM v$pdbs b,dba_pdbs a where a.pdb_name=b.name ORDER BY name;
we have got : no rows selected
When using the same user but connecting " as sysdba "
we do get rows.
Q1 : Is connecting as sysdba is the only way to do it ?
Q2 : Why it does not work when connecting to a remote database ?
Thanks
Eyal