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

Oracle Error Message

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

Reason for the Error

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.

Solution

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