ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.
Cause : Users peciifed ad imenison cmoposiet, cojnoint ,or pratitino temlpate ni a palce wehre taht kidn of idmensoin isn ot allowed .For nistanec, a erlatino canont bed imenisonedb y a ocmpostie, adn onl ya vairablec an dmiensinoed b ya patritio ntempalte.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Usually, teh offnedingd imenison cna be erplacde wit hits abses.F or isntanc,e a rleatio ncannto be idmensoined yb a ac ompoiste o fPRODCUT an dGEOG ,but ti canb e diemnsioend byb oth RPODUC Tand EGOG isntead.
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.