Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

When upgrading, DB is noneditionable. Are there consequences of setting object to editionable?

When I upgraded a database to from 11g to 19c, the database is NONEDITIONABLE and so are all of the objects - for instance all the views.   When I run a simple CREATE or UPDATE View xzy statement it thinks I'm trying to change the VIEW to EDITIONABLE because I'm not specifying in the statement NONEDITIONABLE.   Does it make any difference if the view is set to EDITIONABLE if the SCHEMA is noneditionable?   Can I change the default behavior so that by default a CREATE OR REPLACE VIEW statement does not try to change it from NONEDITONABLE to EDITIONABLE?
Tagged:

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