1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| connect strmadmin/strmadmin@sid1
DECLARE
iSCN NUMBER;
BEGIN
SELECT dbms_flashback.get_system_change_number()
INTO iSCN
FROM dual@sid2;
exec DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN(
source_object_name => 'MYUSER.MYTABLE',
source_database_name => 'SID2',
instantiation_scn => iSCN);
SELECT dbms_flashback.get_system_change_number()
INTO iSCN
FROM dual@sid3;
exec DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN(
source_object_name => 'MYUSER.MYTABLE',
source_database_name => 'SID3',
instantiation_scn => iSCN); |
Partager