ORA-38428: too many attributes selected for indexing



ORA-38428: too many attributes selected for indexing..

Answer / guest

Cause: An attempt was made to create an expression filter
index with more than 490 indexed attributes.

Action: Remove some of the indexed attributes. Make sure
that the default indexed attributes associated with the
attribute set combined with the indexed attributes specified
in the Create Index Parameters clause are less than or equal
to 490.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2F-00325: None of the characters in a name were legal identifier characters

1 Answers  


ORA-13231: failed to create index table [string] during R-tree creation

1 Answers  


ORA-25461: rule set not specified

1 Answers  


RMAN-08159: executing global script: string

1 Answers  


ORA-00161: transaction branch length string is illegal (maximum allowed string)

1 Answers  






LRM-00106: out of memory

1 Answers  


ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  


ORA-06804: TLI Driver: could not bind an IPX address at initialization

1 Answers  


NNO-00155: warning: hint number has missing address, hint ignored

1 Answers  


QSM-02027: group by ROLLUP

1 Answers  


ORA-16073: archiving must be enabled

1 Answers  


Categories