Oracle Error ORA-26687: no instantiation SCN provided for “string”.”string” in source database “string”

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