ORA-26687: no instantiation SCN provided for [TABLE] in source database [DATABASE]
Current DB Version:10.2.0.2
Error:
ORA-26687: no instantiation SCN provided for [TABLE] in source database [DATABASE]
Issue:
While inserting data through replication process between source and target databases using streams, got below error message in APPLY process.
ORA-26687: no instantiation SCN provided for [TABLE] in source database [DATABASE]
Solution:
Run the below command as a stream admin user in the Source DB,
SQL> SELECT * FROM DBA_CAPTURE_PREPARED_TABLES;
You will get the SCN for the corresponding table and use in Destination DB.
Enter instantiation_scn(iscn) that you got at the source.
SQL> BEGIN
DBMS_APPLY_ADM.SET_TABLE_
source_object_name => 'schema.tablename',
source_database_name => 'global db name of source',
instantiation_scn => &iscn);
END;
/
Now start the APPLY process using below command. and also check the status of the process.
SQL> exec dbms_apply_adm.start_apply(
SQL> SELECT APPLY_NAME,QUEUE_NAME,RULE_ SET_NAME,NEGATIVE_RULE_SET_ NAME,STATUS FROM DBA_APPLY;
Thank you for your comment !