Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

NNC-00415: section identifier string is invalid, must be between string and string

1 Answers  


LRM-00117: syntax error at 'string' at the start of input

1 Answers  


ORA-24776: cannot start a new transaction

1 Answers  


RMAN-06012: channel: string not allocated

1 Answers  


ORA-13751: "SQL Tuning Set" "string" does not exist or user "string" is not the owner of the "SQL Tuning Set".

1 Answers  


PLS-00421: synonym definitions nested too deeply; possible loop in synonyms

1 Answers  


ORA-39067: Unable to close the log file.

1 Answers  


ORA-32052: failed to start mapping service

1 Answers  


DRG-10520: failed to drop index: string

1 Answers  


PLS-00376: illegal EXIT statement; it must appear inside a loop

1 Answers  


RMAN-06182: archive log larger than MAXSETSIZE: thread string seq string string

1 Answers  


ORA-23328: mview base table "string"."string" differs from master table "string"."string"

1 Answers  


Categories