11.2.0.2.0
I have a number of large tables that I can compress as theyll either have little or no DML going forward. We have Enterprise edition but not the advanced compression licence so Im limited to Basic compression. Ive read the docs and reviewed JLs note Compression in Oracle – Part 1: Basic Table Compression – All Things Oracle
and I know how to create a table with basic compression and understand that only direct inserted data is compressed post compression.
Question, Is it possible to put basic compression on a tablespace and add tables there as I see fit or is basic compression only at the table level? I cant find a doc to say one or the other.