2 Replies Latest reply: Feb 27, 2012 2:08 PM by Balazs Papp RSS

    Getting right SCN to start streams after imp

    920032
      Hi

      I have a streams configuration that's working perfectly well but I have one problem with starting it on production env.

      I did exp on production database and imported it on target database.

      While starting streams on target database I'm using following code:

      -----
      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;
      -----

      But this way after starting capture and apply I do have a gap between the time of export and the time of configuring and starting streams.

      How should I set SCN to start the replication so there is no gap?

      Thanks for any ideas...