ORA-64307 with HCC over dNFS after Solaris upgrade to 11.4
We upgraded out operating system from 11.3 to 11.4, SunOS dbhost 5.11 11.4.5.3.0 sun4v sparc sun4v,
Now when we try to query a table using Exadata Hybrid Columnar Compression where the datafiles are on NFS, and using dNFS, we get this error.
SQL> select 1 from gwbcntx;
Error starting at line : 2 in command -
select 1 from gwbcntx
Error report -
ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
I tried a test database server already upgraded, and when I try to create a new table using compression I get the same error.
SQL> create table test (
2 col1 number
3 ) COLUMN STORE COMPRESS FOR QUERY HIGH;