Reset EDITIONS
I started experimenting with Editions on 19.20.0.0.0.
I'd like to start afresh but it seems I now permanently have some dependant AQ objects marked as invalid, and as having EDITION_NAME of ORA$BASE.
My initial steps were:
GRANT CREATE ANY EDITION, DROP ANY EDITION TO the_user; ALTER USER the_user ENABLE EDITIONS FORCE; -- I think this made the AQ objects editionale
Now some objects i n this users schema are showing as having EDITION_NAME of ORA$BASE.
I want to start over , as I need to test my changes which also means testing the apply and backout to undo the changes.