I am using Invantive SQL for Exact Online to integrate BOARD with Exact Online. For caching, Invantive Data Cache is configured. By default the data remains fresh enough for the
/*+ ods */ hint to be used for 7 days.
I can switch the Data Cache fully off using
/*+ ods(false) */, but how can I specify a different required freshness other than by dropping the internal tables maintained by Data Cache?