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 DEFAULT or FORCE, but not the syntax. Same issue for the ALTER TABLE statement. What is the correct syntax?

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.