ORA-64307:Exadata Hybrid Columnar Compression is not supported after OS Upgrade
(Doc ID 2024315.1)
Last updated on JANUARY 24, 2020
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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |