This content has been marked as final. Show 2 replies
It seems that I cannot do columnar compression on a cache table?
Learn from the SQL Reference PDF, SQL Statements --> CREATE TABLE --> In-memory columnar compression of tables --> Description
Compression is not supported on columns in replicated tables, cache group tables, grid tables, or on global temporary tables._
OK, then I'll just drop this idea behind..
BTW, if I could have read this description earlier (or I can googled this, or this description could be placed at somewhere more seductive), lots of time would be saved. :0)
Gurus, please correct me if something wrong.
Furthermore, the columnar compression feature is only licensed for use in TimesTen for Exalytics running on Exalytics hardware. It is not licensed for use in any other configuration.