I could not find the exact syntax for the "Result_Cache" clause in the Oracle 19c documentation for the
CREATE TABLE statement. It mentions the values of
FORCE, but not the syntax. Same issue for the ALTER TABLE statement. What is the correct syntax?
After some experimentation, and some almost useful error messages, I was able to do this:
alter table SCOTT.EMP result_cache (mode force);
The RESULT_CACHE_Clause (note the underscores everywhere) is documented in Oracle 21c, along with the additional new settings for 21c.