ORA-26687: no instantiation SCN provided for [TABLE]

 

Error: ORA-26687: no instantiation SCN provided for [TABLE] in source database [DATABASE] Current DB Version: 10.2.0.2

 

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_INSTANTIATION_SCN ( 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(apply_name=>'apply_process_name');   SQL> SELECT APPLY_NAME,QUEUE_NAME,RULE_SET_NAME,NEGATIVE_RULE_SET_NAME,STATUS FROM DBA_APPLY;