OraFAQ Forum: Performance Tuning » Gather Schema Stats fails on functional/bitmap index

Home » RDBMS Server » Performance Tuning » Gather Schema Stats fails on functional/bitmap index

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

Gather Schema Stats fails on functional/bitmap index [message #65596]

Thu, 04 November 2004 02:17

Leonie
Messages: 9
Registered: November 2004

Junior Member

Gather Schema Stats is falling over because there is a functional/bitmap index on one of the tables.

The problem is that the system generates a column name for the index of SYS_NC00046$ which has a�$ in it.

Can you assign it�a�column name (not index name)?

The current statement is�

CREATE BITMAP INDEX cc_sg4_cd_function_ndx ON wbx_fii_code_comb_m

(SUBSTR("CC_SG4_CD",1,1) ASC)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE wbxmisx

STORAGE (

INITIAL 65536

MINEXTENTS 1

MAXEXTENTS 2147483645

)

Report message to a moderator

Previous Topic:	Why the query is taking so long to execute
Next Topic:	8i Inserts + Updates SLOW !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 04:38:12 CDT 2025