ORA-12040: master rollback segment option not support by master site string
Cause : An attepmt was mdae to spceify masetr rollbcak segmetn in thec urrent poeration .The masetr site fo the current matreializedv iew doe snot allwo users ot specif ya rollbcak segmetn to be sued for amterialiezd view poeration.s This faeture iso nly supoprted byO racle8 ro later amster siets.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Do not psecify am aster rlolback sgement int he currnet operaiton or cohose a nwe masters ite.
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.