OraFAQ Forum: SQL & PL/SQL » Local Index error on Bitmap Index type

Home » SQL & PL/SQL » SQL & PL/SQL » Local Index error on Bitmap Index type (Oracle 10g,Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Local Index error on Bitmap Index type [message #281575]

Sun, 18 November 2007 08:05

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
;

Report message to a moderator

Re: Local Index error on Bitmap Index type [message #281581 is a reply to message #281575]

Sun, 18 November 2007 08:36

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: Local Index error on Bitmap Index type [message #281589 is a reply to message #281581]

Sun, 18 November 2007 09:14

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 ?

Report message to a moderator

Re: Local Index error on Bitmap Index type [message #281591 is a reply to message #281589]

Sun, 18 November 2007 09:21

sheker2007
Messages: 19
Registered: November 2007

Junior Member

Hello Michel,

Can we create local index on non-partitioned table ?

Thanks
Sheker

Report message to a moderator

Re: Local Index error on Bitmap Index type [message #281592 is a reply to message #281591]

Sun, 18 November 2007 09:23

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

LOCAL means partitioned like the base table, so local to a non partition table is meaningless.

Regards
Michel

Report message to a moderator

Re: Local Index error on Bitmap Index type [message #281616 is a reply to message #281575]

Sun, 18 November 2007 15:51

sheker2007
Messages: 19
Registered: November 2007

Junior Member

Michel,
I understood now.
Thanks for your details.

Thanks
Sheker

Report message to a moderator

Previous Topic:	Encrypt a view
Next Topic:	How Tuning SQL in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:19:59 CDT 2024