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

ORA-17621: failed to register the memory with Oracle Disk Manager library

1 Answers  


RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

1 Answers  


PCC-00080: TYPE identifier already TYPEd

1 Answers  


ORA-01488: invalid nibble or byte in the input data

1 Answers  


ORA-13761: invalid filter

1 Answers  






TNS-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

1 Answers  


ORA-19595: archivelog string already included in backup conversation

1 Answers  


RMAN-20001: target database not found in recovery catalog

2 Answers  


TNS-00508: No such protocol adapter

1 Answers  


TNS-00208: Logging : string

1 Answers  


TNS-12556: TNS:no caller

1 Answers  


TNS-00014: INTCTL: error while opening terminal input channel

1 Answers  


Categories