SQL Performance (MOSC)

MOSC Banner

Outlin migration

edited Aug 16, 2017 5:00AM in SQL Performance (MOSC) 3 commentsAnswered

The outlin is transfer from 11g to 12c by import export.

try to use DBMS_SPM.MIGRATE_STORED_OUTLINE to migrate the outlin to SPM. but still find the outlin "NOT-MIGRATED"

and get the following output

Summary:

--------

Number of stored outlines to be migrated: 1

Stored outlines migrated successfully: 0

Stored

outlines failed to be migrated: 1

Summary of Reasons for failure:

-------------------------------

Number of invalid stored outlines: 1

Details on stored outlines not migrated or name changes

during migration:

-------------------------------------------------------------------------

* Notes on name change:

* New SQL plan baselines are assigned the same names as their original

* stored

outlines. If a stored outline has the same name as an existing

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