30 of 38
Usage #3: Example
uCreate table A
(a number primary key);
u
uCreate table B (a number,
u                b number);
u
u
uAlter table B
u      add constraint a_fk
u      foreign key (a)
u    references A(a) deferrable
   initially deferred;
Procedure copy_link_a
Is
pragma autonomous_transaction;
Begin
execute immediate
‘create table a_copy_’
   ||to_char (sysdate,’ddmmyyyy’)
  ||’ as select * from a@link’;
  
commit;
End;
Begin
populate_b;
copy_link_a (sysdate);
populate_a;
End;