|
Code Listing 2: Getting and setting the instantiation SCN
DECLARE
source_scn NUMBER;
BEGIN
source_scn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN@TEST10G2(
source_object_name => 'scott.emp',
source_database_name => 'TEST10G1',
instantiation_scn => source_scn);
END;
/
|