Search notes:

ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

Create a partitioned table (or more precisely: a list partitioned table):

create table tq84_tab_part (
   id     number,
   val    number,
   txt    varchar2(10),
   grp    varchar2( 3)  not null check (grp in ('A', 'B', 'C')),
   --
   constraint tq84_tab_part_pk primary key (id)
)
partition by list (grp) (
   partition tq84_list_partition_A values ('A'),
   partition tq84_list_partition_B values ('B'),
   partition tq84_list_partition_C values ('C')
);

Try to create a bitmap index on the partitioned table:

create bitmap index tq84_tab_part_ix_bmp on tq84_tab_part(txt);

This is not possible, Oracle throws a ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables error.

The LOCAL keyword is required to create a local bitmap index:

create bitmap index tq84_tab_part_ix_bmp on tq84_tab_part(txt) local;

cleaning up:

drop   table tq84_tab_part;

ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

See also