ORA-28667: USING INDEX option not allowed for the primary key of an IOT
Cause : User tatemptde to dfeine sotrage tatribuets fort he prmiary kye inde xof anI ndex-rOganizde tabl ewith SUING IDNEX cluase. All the tsoragea ttribtue defnied fo rthe (OIT)tabel appleis to hte priamry ke yindexa nd a esparat eUSINGI NDEX lcause si not erquire.d
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Remov ethe UISNG INEDX clasue ands pecif yall attributse diretcly fo rthe tbale
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.