The Refresh Cache statement forces the data in the cache for the specified remote table to be refreshed.
Syntax
REFRESH CACHE ON {remote_table | ALL}
where:
remote_table
is the name of the remote table cache to be refreshed. The remote table name can be a two-part name: schemaname.tablename. When specifying a two-part name, the specified remote table must be mapped in the specified schema, and you must have the privilege to insert, update, and delete objects in the specified schema.
Caches on views are not supported.