ORA-38499: expression set already configured for
stored/indexed attributes



ORA-38499: expression set already configured for stored/indexed attributes..

Answer / guest

Cause: The expression set already had a list of stored and
indexed attributes. Additional attributes cannot be
specified in the CREATE INDEX parameters clause.

Action: Remove TOP, STOREATTRS and INDEXATTRS clauses from
the parameters clause or clear the expression set statistics
using DBMS_EXPFIL.INDEX_PARAMETERS API.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22861: invalid user-defined type

1 Answers  


ORA-32005: error while parsing size specification [string]

1 Answers  


LPX-00603: Invalid attribute value '~1S': {element '~2S', attribute '~3S'}.

1 Answers  


ORA-02223: invalid OPTIMAL storage option value

1 Answers  


LSX-00311: local element or attribute shouldn't be namespace qualified

1 Answers  


ORA-28120: driving context already exists

1 Answers  


RMAN-06434: some errors occurred while removing recovery catalog

1 Answers  


DRG-50603: unrecognized operation code string

1 Answers  


ORA-24047: invalid agent name string, agent name should be of the form NAME

1 Answers  


ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

1 Answers  


ORA-33058: (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.

1 Answers  


TNS-00521: Missing keyword

1 Answers  


Categories