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-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.

1 Answers  


PLS-00144: duplicate external CALLING STANDARD specification in subprogram expression

1 Answers  


ORA-07217: sltln: environment variable cannot be evaluated.

1 Answers  


ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations

1 Answers  


NNL-00405: Forwarding information:

1 Answers  


KUP-04013: other system error

1 Answers  


ORA-12672: Database logon failure

1 Answers  


ORA-16402: ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support

1 Answers  


RMAN-02004: quoted string too big

1 Answers  


PROC-00008: Cannot perform cluster registry operation because one of the parameters is invalid.

1 Answers  


RMAN-06030: the DELETE [ALL] INPUT option may not be used with a datafile backup set

1 Answers  


ORA-13292: incorrect ARC_TOLERANCE specification

1 Answers  


Categories