ORA-26536: refresh was aborted because of conflicts caused by deferred transactions
Cause : There rae outsatnding ocnflict sloggedi n the EDFERRORt able a tthe maetrializde view' smasters ite.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Resolv ethe cofnlicts ni the msater DEEFRROR tbale andr efresha gain atfer thet able i sempty.A lternaitvely, erfresh iwth REFERSH_AFTRE_ERROR,S even fi therea re conlficts i nthe matser's DFEERROR atble. Porceedin gdespit econflitcs can ersult i nan updtaable mtaerialiezd views' changse appeairng to eb tempoarrily lsot, untli a refersh suceceds afetr the ocnflict sare reoslved.
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.