PDB Support
SQL*Plus includes support for the multitenant architecture.
The SHOW
command displays information about PDBs.
SQL> SHOW CON_ID CON_ID ------------------------------ 1 SQL> SHOW CON_NAME CON_NAME ------------------------------ CDB$ROOT SQL> SHOW PDBS CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO
Command History
Before we can use the HISTORY
command we have to make sure it is turned on. In the example below we attempt to use the HISTORY
command with no options and we are told the HISTORY
command is not enabled, so we enable it as instructed. Continue reading SQL*Plus Enhancements