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 revisionNext revisionBoth sides next revision | ||
| database:oracle:sqlplus [2023/04/12 18:22] – odefta | 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) ====== | ====== 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> | <code sql> | ||
| Line 5: | 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: | ||
database/oracle/switch-to-pluggable-db-sqlplus.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1