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

IMG-00813: boundary queue free failed

1 Answers  


ORA-07638: smsget: SGA pad area not large enough for created SGA

1 Answers  


ORA-24753: local transactions cannot be detached

1 Answers  


DRG-12224: use ctx_ddl.create_section_group to create section groups

1 Answers  


ORA-32311: materialized view definition query selects an unsupported user-defined type

1 Answers  






ORA-01512: error renaming log file string - new file string not found

1 Answers  


ORA-31115: XDB configuration error: string

1 Answers  


DRG-12411: SQL processing error: string

1 Answers  


ORA-07477: scgcmn: lock manager not initialized.

1 Answers  


ORA-24502: codepoint length overflows

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


TNS-12679: Native services disabled by other process but required

1 Answers  


Categories