Database Administration (MOSC)

MOSC Banner

Connecting and querying a container

edited Jul 22, 2015 10:04AM in Database Administration (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center