How to enable INMEMORY JOIN GROUP in Oracle 12.2
No you need also a column for the departments table


CREATE TABLE employees(department_id int)


✓




CREATE TAble departments(department_id int)


✓




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


✓


db&lt;&gt;fiddle here