Edition Based Redefinition Default Edition not selected 19c
Hi - we have set the database default edition to ORA$BASE, however this isn't being selected by default when starting a session - although we can switch to it using ALTER SESSION ok. There is no logon trigger in the account so isn't being changed at logon.
See below:
[cam98dev] >sqlplus mlpit22@cam98dev
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 3 11:45:54 2020
Version 19.7.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Enter password:
Last Successful login time: Wed Jun 03 2020 08:22:14 +01:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0
SQL> show edition
EDITION
------------------------------
ED_002_UCLI
SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_EDITION';