ORA-64307:Exadata Hybrid Columnar Compression is not supported after OS Upgrade
Last updated on APRIL 26, 2018
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterLinux x86-64
Symptoms
After OS or kernel upgrade to RHEL7/OEL7, select on existing HCC tables/creating new HCC Tables will throw below errors
sql>create table testhcc (aa number(5)) compress for query high tablespace datcog;
ERROR at line 1:
ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type
sql>select * from USER.HCC_TAB where rownum < 5;
select * from USER.HCC_TAB where rownum < 5
*
ERROR at line 1:
ORA-64307: Exadata Hybrid Columnar Compression is not supported for
tablespaces on this storage type
ERROR at line 1:
ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type
sql>select * from USER.HCC_TAB where rownum < 5;
select * from USER.HCC_TAB where rownum < 5
*
ERROR at line 1:
ORA-64307: Exadata Hybrid Columnar Compression is not supported for
tablespaces on this storage type
The referenced tablespace (datcog) is on dNfs
Verified DNFS and other attributes and everything does looks intact.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms