Creating a Partitioned Bitmap Index
Bitmap indexes can be created on partitioned tables, but they must be created as local partitioned indexes. For example,
CREATE BITMAP INDEX employees_part_1i
ON employees_part (department_id)
LOCAL;
Oracle will not allow you to create bitmap indexes on partitioned tables unless they are local partitioned indexes. If you attempt to create a non-partitioned bitmap index on a partitioned table, you will receive the following error:
SQL> CREATE BITMAP INDEX employees_part_1i
2 ON employees_part (department_id);
on employees_part (department_id)
*
ERROR at line 2:
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
In the same manner, globally partitioned bitmap indexes are also not ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
