ALTER SESSION SET CONTAINER

How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode

by Ed Chen
November 14, 2022November 21, 2022

ORA-65054 Tried to open a pluggable database (PDB), but it failed with ORA-65054. Let's see how it happened. SQL> alter session set container=ORCLPDB; Session altered.… Read More »

How to Resolve ORA-65000: missing or invalid pluggable database name

by Ed Chen
October 15, 2021October 11, 2021

ORA-65000 Tried to close a pluggable database (PDB) and got error ORA-65000. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database close immediate; alter… Read More »

How to Resolve ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database

by Ed Chen
August 11, 2021March 14, 2022

ORA-65118 When we tried to close a pluggable database (PDB), we got ORA-65118. SQL> alter pluggable database FINPDB close; alter pluggable database FINPDB close *… Read More »

Switch Tablespace To Copy

by Ed Chen
May 16, 2016October 16, 2022

Move Tablespace by RMAN No like we move individual data file to another place by RMAN, changing the location of a tablespace by RMAN is… Read More »

Alter Database Move Datafile

by Ed Chen
May 16, 2016October 16, 2022

Move Data File Online Since 12c, we can move data files online simply by one SQL statement. In other words, we move it by ALTER… Read More »