Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

ORA-64307 with HCC over dNFS after Solaris upgrade to 11.4

edited Feb 25, 2019 8:48PM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 5 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center