Skip to Main Content

Hardware

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HCC row level locking

Arturo GutierrezJan 7 2016 — edited Jan 29 2016

Hello,

Using the last ZFS simulator 8.3, and trying to create a HCC table with new option to enable row level locking, fails with this error:

SQL> create table empleados3

  2  enable row movement

  3  tablespace hcc

  4  column store compress for query low row level locking

  5  as select * from empleados2 order by employee_id;

as select * from empleados2 order by employee_id

                 *

ERROR at line 5:

ORA-64309:  Hybrid Columnar Compression with row-level locking is not supported for tablespaces on this storage type.

I can create tables using HCC, but not with the row level locking.

Any idea how to fix this problem?

Thanks

Arturo

Comments
Post Details
Added on Jan 7 2016
1 comment
1,107 views