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

RMAN-06605: old RMAN configuration parameters are successfully deleted

1 Answers  


ORA-23434: master site string not known for object group

1 Answers  


ORA-19616: output filename must be specified if database not mounted

1 Answers  


ORA-06431: ssaio: Invalid Block number

1 Answers  


ORA-09832: infoCallback: bad message format.

1 Answers  






QSM-01056: no query rewrite for this DDL expression

1 Answers  


ORA-30001: trim set should have only one character

1 Answers  


ORA-32615: incorrect use of MODEL IS ANY predicate

1 Answers  


ORA-13050: unable to construct spatial object

1 Answers  


ORA-25471: attribute name not specified for variable: string

1 Answers  


IMG-00602: unable to access image data

1 Answers  


ORA-02730: osnrnf: cannot find user logon directory

1 Answers  


Categories