ORA-31969: ZONEMAP not supported for table stored in tablespace of this storage type

Attempting to create zone map on non-Exa storage failed – meaning that zone map are not supported on non-Exadata storage ( I am on 12.1.0.2 )

rajesh@PDB1> select default_tablespace

  2  from user_users;

 

DEFAULT_TABLESPACE

------------------------------

DATA_12C 

1 row selected. 

rajesh@PDB1>

rajesh@PDB1> select tablespace_name,extent_management,

  2      allocation_type,segment_space_management,

  3      predicate_evaluation

  4  from dba_tablespaces

  5  where tablespace_name ='DATA_12C' ;

 

TABLESPACE_NAME                EXTENT_MAN ALLOCATIO SEGMEN PREDICA

------------------------------ ---------- --------- ------ -------

DATA_12C                       LOCAL      SYSTEM    AUTO   HOST

 

1 row selected. 

rajesh@PDB1>

rajesh@PDB1>

rajesh@PDB1> create table mysales

  2  ( sales_id number,

  3    prod_id  number,

  4    cust_id  number,

  5    trans_amt number )

  6  clustering by linear order(cust_id)

  7  with materialized zonemap ;

create table mysales

*

ERROR at line 1:

ORA-31969: ZONEMAP not supported for table stored in tablespace of this storage type 

rajesh@PDB1>