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