RESULT_CACHE (MODE DEFAULT) in Table DDL

Issue: Export DDL generated global temporary and all other tables with RESULT_CACHE clause. The syntax is invalid for global temporary tables (can’t test right now but looks right based on documentation) and generated an error when formatting.

CREATE GLOBAL TEMPORARY TABLE gt
(
li_said NUMBER,
col2 VARCHAR2 (4000)
) ON COMMIT DELETE ROWS
RESULT_CACHE (MODE DEFAULT);

Solution idea: Make result_cache an optional clause in supported environments like compress, parallel, logging, etc. Possible options: only non-default, always, and never.

We’ve had a few requests for this since 11gR2 came out. I’ll add it.