ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
Cause : ARPCEMOUPETc alsu eaw spscefiei dnit ehA GGAM Pof r aERALITNOo ev r aabeso f aOCPMERSSDEC MOOPISET ,ub tGAIGDNXEw saO N
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
eRomevt ehP EROCPMTU Elcuaesf or mht eGAMGPA ,roa ddA GGNIED XFOF
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.