database:oracle:switch-to-pluggable-db-sqlplus
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
database:oracle:sqlplus [2023/04/12 18:23] – odefta | database:oracle:switch-to-pluggable-db-sqlplus [2023/04/12 18:26] – odefta | ||
---|---|---|---|
Line 7: | Line 7: | ||
</ | </ | ||
Then you'll be required to enter the SYS password. \\ | Then you'll be required to enter the SYS password. \\ | ||
- | If you use a non dba user, don't specify 'as SYSDBA' | + | < |
- | Here PMJ is the name of the pluggable database.\\ | + | * If you use a non dba user, don't specify 'as SYSDBA' |
+ | | ||
+ | </ | ||
Another way to switch to a PDB is to change the container: | Another way to switch to a PDB is to change the container: | ||
Line 28: | Line 30: | ||
sqlplus /nolog | sqlplus /nolog | ||
connect SNT@PMJ | 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 ' | ||
- | |||
- | spool C: | ||
- | @C: | ||
- | spool off | ||
- | exit | ||
- | |||
</ | </ |
database/oracle/switch-to-pluggable-db-sqlplus.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1