ORA-28667: USING INDEX option not allowed for the primary
key of an IOT



ORA-28667: USING INDEX option not allowed for the primary key of an IOT..

Answer / guest

Cause: User attempted to define storage attributes for the
primary key index of an Index-Organized table with USING
INDEX clause. All the storage attribute defined for the
(IOT)table applies to the primary key index and a separate
USING INDEX clause is not required.

Action: Remove the USING INDEX clause and specify all
attributes directly for the table

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16744: The DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full.

1 Answers  


TNS-01181: Internal registration connection limit reached

1 Answers  


ORA-30081: invalid data type for datetime/interval arithmetic

1 Answers  


PLS-00143: duplicate external LANGUAGE specification in subprogram expression

1 Answers  


ORA-19725: can not acquire plug-in enqueue

1 Answers  






ORA-06115: NETTCP: unable to create ORACLE logicals

1 Answers  


ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW

1 Answers  


TNS-01183: Listener rejected registration or update of instance "string"

1 Answers  


ORA-31512: name cannot contain double quotation marks

1 Answers  


DRG-10303: could not queue given commands to be processed

1 Answers  


DRG-11206: user filter command string could not be executed

1 Answers  


ORA-38468: column "string" is not identified as a column storing expressions.

1 Answers  


Categories