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

LPX-00283: document encoding is ~s-based but default input encoding is not

1 Answers  


ORA-30658: attempt was made to create a temporary table with EXTERNAL organization

1 Answers  


ORA-13009: the specified date string is invalid

1 Answers  


NID-00315: Operation already in progress, continuing

1 Answers  


TNS-12232: TNS:No path available to destination

1 Answers  






TNS-12569: TNS:packet checksum failure

1 Answers  


ORA-07750: slemcr: fopen failure

1 Answers  


ORA-24438: Invalid Authentication Handle specified.

1 Answers  


ORA-40204: model string already exists

1 Answers  


ORA-01297: redo version mismatch between dictionary string and logfiles

1 Answers  


ORA-25125: BUFFER_POOL storage option not allowed

1 Answers  


ORA-38493: feature not enabled : Expression Filter index

1 Answers  


Categories