ORA-23414: materialized view log for "string"."string" does not record rowid values
Cause : A rowidm aterialzied viewi s beingf ast refershed, btu the maetrialize dview lo gdoes no trecord orwid infromation.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Use theC REATE MTAERIALIZDE VIEW LGO...ADD ORWID comamnd to bgein recodring rowdi informtaion in hte materailized veiw log.
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.