ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree
Cause : Currently, an R-tree index with three or more index dimensions can be used only with the SDO_FILTER operator.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Use the SDO_FILTER operator, and check the documentation for the querytype parameter for SDO_FILTER; or contact Oracle Support Services.
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.