Home » SQL & PL/SQL » SQL & PL/SQL » Local Index error on Bitmap Index type (Oracle 10g,Solaris)
Local Index error on Bitmap Index type [message #281575] Sun, 18 November 2007 08:05 Go to next message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Hello Experts,i need help...

I need to create local bitmap index on non partitioned table.
I am getting below error

ORA-14016: underlying table of a LOCAL partitioned index must be partitioned

CREATE BITMAP INDEX AFSDBOD.W_CHNG_IDX1 ON DBOD.W_CHNG(LN_TYPE)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE XYZ_IDX_01
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
)
LOCAL
;

Re: Local Index error on Bitmap Index type [message #281581 is a reply to message #281575] Sun, 18 November 2007 08:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:

I need to create local bitmap index on non partitioned table.

So does not give the "LOCAL" keyword.

When you copy a statement, you have to understand it if you want to avoid raw mistake.

Regards
Michel
Re: Local Index error on Bitmap Index type [message #281589 is a reply to message #281581] Sun, 18 November 2007 09:14 Go to previous messageGo to next message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Hello Michel,

Thanks for your reply.

But i want local index only.
I want to use Partition Exchange between two tables.(one table is not partitioned and other one is partitioned).
Any suggestion ?
Re: Local Index error on Bitmap Index type [message #281591 is a reply to message #281589] Sun, 18 November 2007 09:21 Go to previous messageGo to next message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Hello Michel,

Can we create local index on non-partitioned table ?

Thanks
Sheker
Re: Local Index error on Bitmap Index type [message #281592 is a reply to message #281591] Sun, 18 November 2007 09:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
LOCAL means partitioned like the base table, so local to a non partition table is meaningless.

Regards
Michel
Re: Local Index error on Bitmap Index type [message #281616 is a reply to message #281575] Sun, 18 November 2007 15:51 Go to previous message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Michel,
I understood now.
Thanks for your details.


Thanks
Sheker
Previous Topic: Encrypt a view
Next Topic: How Tuning SQL in Oracle
Goto Forum:
  


Current Time: Wed Nov 13 06:56:35 CST 2024