Differences

This shows you the differences between two versions of the page.

--- database:oracle:switch-to-pluggable-db-sqlplus [2023/04/12 18:25] – removed - external edit (Unknown date) 127.0.0.1
+++ database:oracle:switch-to-pluggable-db-sqlplus [2023/04/12 18:25] – ↷ Page name changed from database:oracle:sqlplus to database:oracle:switch-to-pluggable-db-sqlplus odefta
@@ Line 1: / Line 1: @@
+====== 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.
+<code sql>
+conn SYS@PMJ as SYSDBA
+</code>
+Then you'll be required to enter the SYS password. \\
+<note>
+  * If you use a non dba user, don't specify 'as SYSDBA' clause.
+  * Here PMJ is the name of the pluggable database.
+</note>
+Another way to switch to a PDB is to change the container:
+<code sql>
+alter session set container=PMJ;
+</code>
+To go back to the CDB container:
+<code sql>
+alter session set container=CDB$ROOT;
+</code>
+====== Connect directly to a pluggable db ======
+<code>
+sqlplus /nolog
+connect SNT@PMJ
+</code>
+====== Format sqlplus output ======
+<code>
+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
+</code>