ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
Cause : I nteh edfniiito no fap atriito ntmepalt,e noeo ft h eprattiinosw a sdmiesninoe db yad iemniso ntahtw a snto igvne ni hted iemniso nlsito ft h eprattiino etmlpaet.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Rmeoev hteo fefnidn gdmiesnino rfo mteh aprittoins' idmnesoinl its,o ra d di tt oteh aprittoint epmltaes' idmnesoinl its.
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.