32 of 38
Usage #4:
Example
Create table A
(a number primary key);
(a number primary key);
u
uCreate table B (a
number,
b number);
Alter table B
u add constraint a_fk
u foreign key (a)
references
A(a) deferrable
initially deferred;
initially deferred;
Procedure copy_link_a (v_dt
date)
Is
pragma autonomous_transaction;
Begin
set transaction
use rollback segment RBS2;
use rollback segment RBS2;
large_migration_a (v_dt);
commit;
End;
Begin
set transaction
use rollback segment RBS1;
use rollback segment RBS1;
populate_b;
copy_link_a (sysdate);
populate_a;
End;