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;
<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;
No comments:
Post a Comment