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:
iscn NUMBER; -- Variable to hold instantiation SCN value
iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER@DB.PROD;
source_schema_name => 'STREAMS_SCHEMA',
source_database_name => 'DB.PROD',
instantiation_scn => iscn,
apply_database_link => null,
recursive => true);
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...