Database Reference
In-Depth Information
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
SQL>
SQL> startup restrict
Pluggable Database opened.
SQL>
SQL> startup force
Pluggable Database opened.
SQL>
SQL> connect sys/system@CONT as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> ALTER SESSION SET CONTAINER=pdb1;
Session altered.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
PDB1
SQL> SELECT NAME, OPEN_MODE FROM v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB1 MOUNTED
SQL> STARTUP
Pluggable Database opened.
SQL> SELECT NAME, OPEN_MODE FROM v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB1 READ WRITE
Search WWH ::
Custom Search