SQL Performance (MOSC)

MOSC Banner

Migrate outline to sql plan is not working

edited Oct 15, 2015 10:05AM in SQL Performance (MOSC) 1 commentAnswered

SQL> variable migrate_out clob SQL> exec :migrate_out :=DBMS_SPM.MIGRATE_STORED_OUTLINE(- attribute_name => 'outline_name', - attribute_value => 'SYS_OUTLINE_10070216402913401',-   fixed => 'NO' );> > > PL/SQL procedure successfully completed. SQL> select :migrate_out from dual; :MIGRATE_OUT -------------------------------------------------------------------------------- ------------------------------------------------------------------------------- MIGRATED    NAME                          CATEGORY ------------ ------------------------------ ------------------------------ NOT-MIGRATED SYS_OUTLINE_10070216402913401  ONLINE_PRE And it is not migrated, can someone take a look? Thanks

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