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-31438: duplicate change table string

1 Answers  


ORA-07598: spwat: $SETIMR failure

1 Answers  


ORA-04934: unable to obtain the current sequence number

1 Answers  


LSX-00143: element "~S" must have type or ref

1 Answers  


ORA-26013: List allocated may not be big enough

1 Answers  






LRM-00100: internal error [number]

1 Answers  


ORA-24181: The type string does not exist

1 Answers  


ORA-30771: Cannot add more than one referential constraint on REF column "string"

1 Answers  


RMAN-06210: List of Mismatched objects

1 Answers  


EXP-00071: QUERY parameter not compatible with Direct Path export

1 Answers  


ORA-31521: CDC subscription string already subscribes to publication ID string column string

1 Answers  


O2U-00207: None of the characters in an attribute name were legal identifier characters

1 Answers  


Categories