Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can you list available PDBs and connect to a specific PDB or CDB in sqlplus?

M.EmmanuelDec 15 2018 — edited Dec 15 2018

I am starting to use Oracle 18 XE (last version I used was 11g).

When I connect to database using:

sqlplus /nolog

and then I type:

connect sys as sysdba

I understand that I am connecting by default to the CDB.

1. How can I check in sqlplus that I am effectively connected to the CDB?

2. How can I list which PDBs are available in that CDB?

3. How can I connect to a given CDB?

Thanks,

This post has been answered by AndrewSayer on Dec 15 2018

Jump to Answer

Added on Dec 15 2018

#general-database-discussions, #sqlplus

3 comments

31,322 views