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

    Switching to PDB from CDB without double quotes seems to fail


      I've upgraded one of our EBS instances from 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;



      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