Friday, October 03, 2008

Move outline between databases (different schemas)

create outline out_1 on
<query>;

create private outline out_prv from out_1;

delete from system.ol$hints;
commit;

insert into system.ol$hints select * from outln.ol$hints@remote_db where ol_name='remote_outline'
;

update system.ol$hints set ol_name='out_prv'

.... change system.ol$hints column user_table_name;

exec dbms_outln_edit.refresh_private_outline('OUT_PRV');

create or replace outline out_1 from private out_prv;