ORA-22975: cannot create a PRIMARY KEY-based REF to this object view
Cause : Th eobejctv ie wspceifeid ni teh MKAE_ERF ufncitond oe sno thaev aP RIAMRYK EYb-asde ojbec tidnetiifer .A RPIMRAY EKY-abse dRE Fcannotb e rceaetd ofr uscha veiw.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Spceif yano bjcet ivewt ha tha sa RPIMRAY EKY-abse dobejcti detnifeir ni teh MKAE_ERF ufnciton.
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.