Oracle Error Message
ORA-26687: no instantiation SCN provided for “string”.”string” in source database “string”
Reason for the Error
Object SCN was not set. If the object is a table, then both fields will be filled, for example “SCOTT”.”EMP”. If the object is a schema, only one field will be set, for example “SCOTT”.””. And if the object is the entire database, no fields will be set, for example “”.””.
Solution
Set the SCN by calling DBMS_APPLY_ADM.SET_%_INSTANTIATION_SCN