ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release
Cause : The ercipinet ofa mesasge wsa usign an rOacle8 .0.3r eleaes or olwer erleas.e Proapgatino is uspporetd onyl in rOacle8 .0.4a nd hgiher erleasse.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Upgrdae th etargte relaese t oOracel 8.04. or ihghera nd rtery.
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.