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

NID-00430: Database is ready to be open or shut down.

1 Answers  


ORA-12046: cannot use trusted constraints for refreshing remote MV

1 Answers  


TNS-12547: TNS:lost contact

1 Answers  


ORA-25198: only range, list, and hash partitioning are supported for index-organized table

1 Answers  


NZE-29117: Cannot add PKCS #12 attributes.

1 Answers  


TNS-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


PLS-00617: at least one result in the CASE expression must not be NULL

1 Answers  


RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

1 Answers  


ORA-06544: PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

1 Answers  


CLSR-01011: Invalid instance startup mode [string] is specified

1 Answers  


ORA-30436: unable to open named pipe 'string'

1 Answers  


ORA-36998: (XSRELGID15) LEVEL ORDER VALUESET workspace object and LEVEL RELATION workspace object have the different level dimensions.

1 Answers  


Categories