My Oracle Support Banner

SET_SCHEMA_INSTANTIATION_SCN / SET_GLOBAL_INSTANTIATION_SCN does not return error if database link is not available (Doc ID 563381.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Information in this document applies to any platform.

Symptoms

Executing DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN or DBMS_APPLY_ADM.SET_GLOBAL_INSTANTIATION_SCN with parameter recursive=true completes successfully eventhough there is no database link link to the source database. This results in the instantiation scn NOT set recursively, leading to error ORA-26687

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.