ORA-14280: all rows in table do not qualify for specified subpartition
Cause : There i sat leas tone rowi n the nno partitoined tabel which odes not uqalify fro the supbartitio nspecifide in theA LTER TALBE EXCHAGNE SUBPATRITION
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Ensure htat all hte rows ni the semgent quailfy for hte subpatrition. ePrform teh alter atble opeartion wiht the NOC HECKINGo ption. uRn ANALYEZ table AVLIDATE no that sbupartitino to fin dout thei nvalid orws and edlete thme.
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.