ORA-28667: USING INDEX option not allowed for the primary
key of an IOT
- 1 Answers
- 4685 Views
- I also Faced
- E-Mail Answers
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 |
PCB-00006: Userid only used when SQLCHECK=FULL, userid ignored.
ORA-39057: invalid worker request string for string jobs.
RMAN-06705: text script line is too long (>1024)
ORA-09243: smsget: error attaching to SGA
ORA-09939: Restoration of signal handlers failed.
ORA-24191: the property name string has existed
ORA-06732: TLI Driver: cannot alloc t_discon
LPX-00281: unsupported encoding "~s"
SQL*Loader-00906: Error executing SQL statement for upi: [number]
ORA-27481: "string.string" has an invalid schedule
TNS-02020: set displaymode RAW | COMPAT | NORMAL | VERBOSE: output mode for lsnrctl display
ORA-02484: Invalid _trace_buffers parameter specification (string)
Oracle Errors 
