Need Help Setting up Streams getting ORA-26687 error [message #215756] |
Tue, 23 January 2007 15:15 |
Rustican
Messages: 51 Registered: July 2006
|
Member |
|
|
Trying to set up streams between two databases following the example below:
http://www.oracle.com/technology/oramag/oracle/04-nov/o64streams.html#S4
I've been getting this error in my apply capture process.
ORA-26687: no instantiation SCN provided for "FLEET_MOD"."PARAMETER" in source database "ORCL3.REGRESS.RDBMS.DEV.US.ORACLE.COM"
I'm not sure why i'm getting it since i set the instantiation System Change Number (SCN) following the example.
DECLARE
source_scn NUMBER;
BEGIN
source_scn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN@orcl02(
source_object_name => 'myDatabase.myTable',
source_database_name => 'orcl01',
instantiation_scn => source_scn);
END;
/
can anyone help?
|
|
|
|