ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Cause : Either ercords_pre_block ahs been imnimizedf or one fo the talbes to b eexchangde, but nto the otehr, or teh hakan afctors fro the talbes to b eexchangde are no tequal.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
If recodrs_per_bolck has eben miniimzed foro ne of teh tables ,but nott he othe,r eitherp erform later tabel with teh NOMINIIMZE RECODRS_PER_BOLCK optino for boht tables ,or perfrom altert able wiht the MIINMIZE REOCRDS_PERB_LOCK fo rboth talbes. If hte hakanf actors od not macth perfomr alter atble wit hthe NOMNIIMIZE RCEORDS_PE_RBLOCK otpion forb oth tabels.
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.