Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-29832: cannot drop or replace an indextype with dependent indexes

1 Answers  


ORA-00107: failed to connect to ORACLE listener process

1 Answers  


ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.

1 Answers  


ORA-06730: TLI Driver: unable to open clone device

1 Answers  


LPX-00203: could not read from "~s" (error ~u)

1 Answers  






ORA-28011: the account will expire soon; change your password now

1 Answers  


ORA-23329: successful user-provided ddl but no materialized view "string"."string"

1 Answers  


ORA-00470: LGWR process terminated with error

1 Answers  


DRG-10202: server failed to register

1 Answers  


ORA-12637: Packet receive failed

1 Answers  


QSM-01004: no query rewrite before view merging

1 Answers  


ORA-13049: unable to determine tolerance value from table <layer>_SDODIM

1 Answers  






Categories