How to fix the Oracle error ORA-28504: ROWID not found in ROWID cache for heterogeneous database link?

In this post, you’ll learn more about the Oracle ErrorORA-28504: ROWID not found in ROWID cache for heterogeneous database link with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28504: ROWID not found in ROWID cache for heterogeneous database link

Reason for the Error ORA-28504: ROWID not found in ROWID cache for heterogeneous database link

The ROWID cache for Heterogeneous Services held no entry that corresponds to the specified ROWID. The ROWID entry may have been overwritten in the ROWID cache.

How to fix the Error ORA-28504: ROWID not found in ROWID cache for heterogeneous database link ?

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

Enlarge the Heterogeneous Services ROWID cache size by increasing the value of the Heterogenous Services initialization parameter HS_ROWID_CACHE_SIZE.