use the keyword LOCAL
"afiedt.buf" 6 lines, 187 characters
1 create table myemp
2 (ename varchar2(14), deptno number, sal number(7,2))
3 partition by range (deptno)
4 (partition myemp_p1 values less than (30),
5* partition myemp_p2 values less than (50))
mag@mutation_mutation > /
Table created.
mag@mutation_mutation > create bitmap index bit_myemp on myemp(ename);
create bitmap index bit_myemp on myemp(ename)
*
ERROR at line 1:
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
mag@mutation_mutation > create bitmap index bit_myemp on myemp(ename) local;
Index created.