database:oracle:switch-to-pluggable-db-sqlplus
This is an old revision of the document!
Table of Contents
Switch to a pluggable db (Oracle 12)
After you are connected with sqlplus to a container database (which is happening by default), run the connect command inside your sqlplus session.
conn SYS@PMJ AS SYSDBA
Then you'll be required to enter the SYS password.
- If you use a non dba user, don't specify 'as SYSDBA' clause.
- Here PMJ is the name of the pluggable database.
Another way to switch to a PDB is to change the container:
ALTER SESSION SET container=PMJ;
To go back to the CDB container:
ALTER SESSION SET container=CDB$ROOT;
Connect directly to a pluggable db
sqlplus /nolog connect SNT@PMJ
Format sqlplus output
set linesize 2500 set wrap off set trimout on set trimspool on set long 100000 set pagesize 0 col inmemory_service_name for a10 col table_name for a10 col cluster_name for a20 col cluster_owner for a20 col iot_name for a10 col default_collation for a10 COLUMN first_name FORMAT A10 WORD_WRAP HEADING 'Name' JUSTIFY CENTER spool C:\buffer\out.txt @C:\buffer\sql.txt spool off exit
database/oracle/switch-to-pluggable-db-sqlplus.1681313136.txt.gz · Last modified: 2023/07/04 19:36 (external edit)