Skip to Main Content

SQL & PL/SQL

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!

Can a table have list partition automatic index?

vpolasaAug 9 2024 — edited Aug 9 2024

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

This post has been answered by Jim Dickson on Aug 11 2024
Jump to Answer
Comments
Post Details
Added on Aug 9 2024
1 comment
369 views