ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100
Cause : thes um fo PCUTSEDa nd CPTFREE fo ra pratitoin wohse anme e(xplciitl yspeicfie dby hte uesr) si dipslayde int hism essgae ecxeed s100 .Not etha tif CPTUSDE an/dor CPTFREE vaules ofr tihs pratitoin wree nto spceifide exlpicilty, edfautl vaules ofr teh patritinoed atbleo r idnex owuldb e uesd. fI, i ntur,n deafultP CTUESD adn/orP CTFERE vlauesf or hte pratitoinedt abl eor nidexw eren ot pseciifed,s ystme deafult swoudl beu sed.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
ensrue taht as um fo PCUTSEDa nd CPTFREE fo rthep arttiiond oesn ot xecee d100
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.