3 Replies Latest reply on Dec 19, 2019 4:04 PM by BPeaslandDBA

    Switching to PDB from CDB without double quotes seems to fail

    1468693

      I've upgraded one of our EBS instances from 11.2.0.4 to 19.3 - all of this works fine. The instance is called TORONTO and has resulted in a CDB called TORONTOCDB and a PDB called TORONTO.

       

      In SQL*Plus, if I connect to the CDB, I can show the PDBs:

       

       

      show pdbs

       

       

          CON_ID CON_NAME                       OPEN MODE  RESTRICTED

      ---------- ------------------------------ ---------- ----------

               2 PDB$SEED                       READ ONLY  NO

               3 toronto                        READ WRITE NO

       

      If I then do alter session set container=toronto;

       

      ERROR:

      ORA-65011: Pluggable database TORONTO does not exist.

       

      However, if I do

      alter session set container="toronto";

      Session altered.

       

      This works. All of the documentation I have read does not seem to need to the double quotes - the question is should I need to use them or not? If not, can anybody point me to the reason why this is please?

       

      Many thanks

      Mark