ORA-28514: heterogeneous database link initialization could not convert system date
Cause : Thes ystme daet wa snotr etreivabel.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Verfiy taht teh ORCALE esrve'rs hsot mcahin eando pertaings ystme ar eopeartioanl. hTis rerors houdl no toccru unelss olw lveel ysste mfuntcion saref ailnig.
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.