As I mentioned in previous post Oracle allowed users to use Hybrid Columnar Compression on ZFS appliance. Two days ago there was a note in MOS about bug/enhancement but there was no patch for it. Yesterday I was able to download patch number 13041324 for Oracle 18.104.22.168 and successfully applied it against my installation on virtual machine. After that I run my Oracle's Sun Unified Storage Simulator and I created a new table space on it using NFS share together with Oracle Direct NFS client. Next I try to create compressed table using old existing table space on local ASM disk and it fail as expected. Than I give a try on new table space and this time table has been created :
SQL> create tablespace SUNNFSTS datafile '/nfs/sunnfsts.dbf' size 10M; Tablespace created. SQL> create table SCOTT.test1 tablespace USERS compress for archive high as select * from dba_objects where rownum < 100; create table SCOTT.test1 tablespace USERS compress for archive high as select * from dba_objects where rownum < 100 * ERROR at line 1: ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type SQL> create table SCOTT.test tablespace SUNNFSTS compress for archive high as select * from dba_objects where rownum < 100; Table created. SQL> exit
Looks like it is working and HCC can be tested without expensive hardware. I hope I will find some time to write down all my notes and create proper blog post about installation and configuration.