ORA-13344: an arcpolygon geometry has fewer than five coordinates
Cause : A geometry, specified as being an arcpolygon, has fewer than five coordinates in its definition.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
An arcpolygon must consist of at least five coordinates. An arcpolygon consists of an ordered sequence of arcs, each of which must be described using three coordinates. Since arcs are connected the end-point of the first is the start of the second and does not have to be repeated. Correct the geometric definition, or set the appropriate SDO_GTYPE or SDO_ETYPE attribute for this geometry.
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.