Database Administration (MOSC)

MOSC Banner

question on edition transition

Guys,


How do you make sure the existing app sessions connect to the new edition once the update/upgrade is complete?


Example, I have users connecting to ora$base. Then I made ddl changes in a new edition called post_upgrade. When all is done, I set default edition for db to post_upgrade so all new connections will be in post_upgrade edition. But the existing connections using the ora$base still remain in ora$base unless they reconnect. My question is how to force the existing connections from ora$base edition to use post_upgrade edition without disconnecting.

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