DECLARE
  iscn  NUMBER;         -- Variable to hold instantiation SCN value
BEGIN
  iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER@DB.PROD;
  DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN(
    source_schema_name    => 'STREAMS_SCHEMA',
    source_database_name  => 'DB.PROD',
    instantiation_scn     => iscn,
    apply_database_link   => null,
    recursive             => true);
END;