Home » RDBMS Server » Performance Tuning » Only LOCAL bitmap indexes are permitted on partitioned tables
Only LOCAL bitmap indexes are permitted on partitioned tables [message #65944] Fri, 04 February 2005 02:12 Go to next message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
16:28:32 SQL> create bitmap index bp_idx_ag_id on transactions(type);
create bitmap index bp_idx_ag_id on transactions(type)
*
ERROR at line 1:
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

how to create bitmap index on partitiioned tables
Re: Only LOCAL bitmap indexes are permitted on partitioned tables [message #65945 is a reply to message #65944] Fri, 04 February 2005 05:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
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.
Re: Only LOCAL bitmap indexes are permitted on partitioned tables [message #65951 is a reply to message #65945] Fri, 04 February 2005 20:36 Go to previous messageGo to next message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
thanks..Mahesh
Re: Only LOCAL bitmap indexes are permitted on partitioned tables [message #504623 is a reply to message #65945] Tue, 26 April 2011 18:46 Go to previous message
ankitamehani
Messages: 1
Registered: April 2011
Location: USA
Junior Member

Thanks, It really helped... Smile
Previous Topic: AWR
Next Topic: Sql tuning
Goto Forum:
  


Current Time: Thu Apr 18 21:05:00 CDT 2024