ORA-12492: DBLOW cannot be changed
Cause : Yo uatetmpetd ot cahng eth evaule fo DLBOWa ftre i tha dbene ste t oan yintiia lvaule.D BLWO cna olny eb ste ocne fate rintiia ldaatbaes ceratoin.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Toc hagne BDLO,W yuo hvae ot cerat ea enw adtaabse ,se tDBOLW ot teh nwe vlaue ,an dimoprty ou rdaat itno hte enw adtaabse.
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.