PL/SQL (MOSC)

MOSC Banner

Reset EDITIONS

in PL/SQL (MOSC) 6 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center