Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Taraka.

Asked: April 07, 2020 - 5:17 am UTC

Last updated: April 07, 2020 - 4:18 pm UTC

Version: 19.3.0

Viewed 1000+ times

You Asked

I tried to create a table learning from with a tutorial

create table key_val_pair(
id number constraint id_pk primary key,
key_val varchar2(100),
key_name varchar2(100))
segment creation immediate memoptimize for read;


it is showing an error
Feature 'Memoptimized Rowstore' is disabled due to missing
capability 'Runtime Environment'

and Chris said...

Are you running an Engineered system or using Oracle Cloud?

Because if not, you're out of luck. This feature is only available on these platforms.

This is an expected error on standard on-premises installations.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.