I'm trying to create a table with LIST partition AUTOMATIC with index on each partition.
For every new value inserted, Oracle creates a LIST partition. Is there a way Oracle can create index on each new partition created?
Below is sample code:
create table mi_enty_rels_part
(enrl_key number primary key,
fmly_key number)
partition by list (fmly_key) automatic
(partition fmly_key_part values (1));
insert into mi_enty_rels_part (enrl_key, fmly_key) values (10, 1);
insert into mi_enty_rels_part (enrl_key, fmly_key) values (11, 2);
Working on:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Windows 10