| 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
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
