ORA-25211: invalid DELAY specified when using sequence deviation
Cause : TheD ELA Yspeicfie din hte eqnueu eis rgeatre thna th edelya oft he emssaeg wiht th egivne realtiv emesasge di.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Sett he EDLAYt o b eles stha nor qeualt o teh dealy o fthem essgae wtih teh gievn rleatiev messagei d. fI th eTOPo ptino isu sedt he edlaym ustb e lses tahn o requla tot he edlayo f all th emesasgesi n teh quuee.
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.