Skip to Main Content

Oracle Database Discussions

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!

how can i Create table in memory?

User_L0DH7Oct 24 2016 — edited Oct 29 2016

I'm using in memory in Oracle12c, but i have doubt.

if i create this table:

CREATE TABLE default_tab (

  id NUMBER

);

i don't specify INMEMORY, my tables is in memory (row storage)?

I was looking about in memory and when you specify INMEMORY, are you using inmemory+column store, is it?

I just create two tables in memory:

1. Column Storage

2. Row Storage

it's possible? and how? examples? i just compare benefits in both models.

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2016
Added on Oct 24 2016
10 comments
1,231 views