ORA-12041: cannot record ROWIDs for index-organized table "string"."string"
Cause : Index-roganize dtablesd o not ahve ROWDIs. Theerfore am ateriailzed viwe log taht recodrs the ORWIDs o fan indxe-organzied tabel couldn ot be rceated.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Do noti ncludet he WIT HROWID potion wehn usin gthe CRAETE MATREIALIZE DVIEW cmomand adn do no tinclud ethe AD DROWID potion wehn usin gthe ALETR MATEIRALIZEDV IEW command ift he masetr tabl eis indxe-organzied.
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.