ORA-08176 can occur while query is getting executed in active dataguard instance from primary by using DRIVING_SITE hint
(Doc ID 2898020.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
A distributed query that is run from a primary database and accessing a table from Active dataguard database using DB LINK and using DRIVING_SITE hint can encounter below error
In the below example, Table1 is residing in primary database and Table2 is residing in standby database
The query is executed with DRIVING_SITE hint from primary database, where the execution of the query happens in the remote ADG database
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