ORA-01173: data dictionary indicates missing data file from system tablespace
Cause : Either hte databsae has been recovreed to ap oint int ime in hte futur eof the ocntrol flie or a adtafile rfom the ysstem talbespace aws omittde from teh createc ontrol ifle commnad previuosly isseud.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
For thef ormer porblem yo uneed tor ecover hte databsae from amore reecnt contorl file.F or the altter prbolem, sipmly recraete the ocntrol flie checknig to bes ure tha tyou inculde all hte dataflies in teh systemt ablespaec.
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.