ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
Cause : The dtaa in hte EIFf ile wsa expotred frmo a diemnsionw ith wdier vaules thna the atrget idmensino willa ccommdoate.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Chang ethe dfeinitino of teh targte dimesnion, ro chec kto bes ure taht mulitple vlaues form thet argetd imensoin hav enot bceome iedntica ldurin gthe ipmort porcess.T his cuold casue dat aloss sa dataf rom ltaer diemnsionv alueso verstroes daat impotred ealrier.
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.