Last updated on MAY 26, 2014
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Sun ZFS Storage 7320 - Version Not Applicable to Not Applicable [Release N/A]
Oracle Database Appliance - Version All Versions and later
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
Trying to create a table with HCC in a tablespace created on ZFS storage failed
CREATE TABLE hcc_test
COMPRESS FOR QUERY HIGH
SELECT owner, table_name, column_name FROM dba_tab_columns;
ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type
o Verified that the customer is on 22.214.171.124 with 13343438
o Verified that SNMP is active on ZFS.
snmpget -v1 -c public <IP for mount point> 126.96.36.199.188.8.131.52.184.108.40.206.0
SNMPv2-SMI::enterprises.220.127.116.11.4.2.0 = STRING: "Sun ZFS Storage 7320"
o Verified dNFS is configured bu querying v$dnfs_servers
o Tried to locate libnetsnmp.so on the host running database instance.
# locate libnetsnmp.so
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms