How to enable INMEMORY JOIN GROUP in Oracle 12.2

1 vote

1 answer

236 views

oracle memory-optimized-tables in-memory-database

                          I have read official Oracle documentation on INMEMORY JOIN GROUP and run code from their tutorials. However I unable to successfully create INMEMORY JOIN GROUP.

- Installed database is Oracle 12.2
- INMEMORY TABLE and INMEMORY COLUMN were created successfully.

Exception message of INMEMORY JOIN GROUP creation below:

    Error starting at line : 1 in command -
    CREATE INMEMORY JOIN GROUP employees_departments
        (employees(department_id), departments())
    Error report -
    ORA-00900: invalid SQL statement
    00900. 00000 -  "invalid SQL statement"
    *Cause:    
    *Action:

My code is

    CREATE INMEMORY JOIN GROUP employees_departments
        (employees(department_id), departments());

Are there any Oracle initialize parameters that should be specified in order to turn on support of INMEMORY JOIN GROUP?



Oracle SQL Developer highlights INMEMORY as incorrect syntax:

                        

Asked by BrilliantContract (113 rep)

Jan 10, 2021, 05:37 PM
Last activity: Jan 10, 2021, 07:18 PM

How to enable INMEMORY JOIN GROUP in Oracle 12.2

Related Questions