Database Administration (MOSC)

MOSC Banner

How to find out which instance is candidate to an edition downgrade from Enterprise to Standard

edited Aug 10, 2011 1:30AM in Database Administration (MOSC) 3 commentsAnswered
 Hi all,

I know there are procedures to test and validate an edition downgrade (using export/import ...), but i'm looking for a way to find out among all my instances which ones could work properly on a standard edition database server.

for example is there any tool or SQL script that tells you if a database instance (or a schema) is only using functionnalities and options compatible with Standard edition ?

The goal is to eliminate instances that must run on EE server before trying the export/import procedure and thus save time.

Thanking you in advance,

Michel Moureaux.

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