Oracle Solution for Error ora-28504

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

What triggered the Error:

e 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.

What should we do to fix it:

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