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

PLS-00315: Implementation restriction: unsupported table index type

1 Answers  


ORA-31013: Invalid XPATH expression

1 Answers  


ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string

1 Answers  


ORA-25019: too much concurreny

1 Answers  


ORA-24781: branches don't belong to the same global transaction

1 Answers  






ORA-06109: NETTCP: message receive failure

1 Answers  


ORA-23393: the user is already the propagator

1 Answers  


ORA-06112: NETTCP: invalid buffer size

1 Answers  


QSM-02091: mv references a non-repeatable or session-sensitive expression

1 Answers  


ORA-12074: invalid memory address

1 Answers  


ORA-16230: committing transaction string string string

1 Answers  


ORA-13509: error encountered during updates to a SWRF table

1 Answers  


Categories