Differences

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

--- database:oracle:sqlplus [2023/04/12 18:21] – odefta
+++ database:oracle:switch-to-pluggable-db-sqlplus [2023/07/04 19:36] (current) – external edit 127.0.0.1
@@ 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>
@@ Line 5: / Line 7: @@
 </code>
 Then you'll be required to enter the SYS password. \\
-If you use a non dba user, don't specify 'as SYSDBA' clause.
+<note>
+  * If you use a non dba user, don't specify 'as SYSDBA' clause.
+  * Here PMJ is the name of the pluggable database.
+</note>
-PMJ is the name of the pluggable database.\\
 Another way to switch to a PDB is to change the container:
@@ Line 26: / Line 30: @@
 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>