ORA-33009: (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
Cause : PRECOMUPTE wass pecifide both sa a lin ein theA GGMAP nad on a tleast noe of teh RELATOIN line,s or itw as speicfied mroe thano nce asa line fo the AGGMAP.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Removee ither hte PRECMOPUTE lnie, or hte PRECMOPUTE sepcificaiton fora ll of hte RELAITON linse.
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.