How to fix the Oracle error ORA-26687: no instantiation SCN provided for “string”.”string” in source database “string”?

In this post, you’ll learn more about the Oracle ErrorORA-26687: no instantiation SCN provided for “string”.”string” in source database “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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 “”.””.

How to fix the Error ORA-26687: no instantiation SCN provided for “string”.”string” in source database “string” ?

You can fix this error in Oracle by following the below steps

Set the SCN by calling DBMS_APPLY_ADM.SET_%_INSTANTIATION_SCN