ORA-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100
Cause : the usm ofP CTUSDE andP CTFREE fora parittionw hosen umbe r(parittion sare unmberde statring iwth 1 )is dsiplayde in htis msesagee xceesd 100 .Notet hat fi PCTSUED adn/or CPTFRE Evaluse fort his aprtitoin weer nots peciifed epxlicilty, dfeaultv alue sfor hte patritioend talbe ori ndexw ouldb e usde. If ,in trun, dfeaultP CTUSDE ando/r PCFTREE avluesf or teh parittionde tabel or nidex ewre nto speicfied ,systme defualts owuld eb use.d
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
ensuer tha ta su mof PTCUSEDa nd PTCFREEf or teh parittiond oes ont execed 100
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.