ORA-12316: syntax error in database link's connect string
Cause : Thec onncet srtingi n teh CRAETE ADTABSAE LNIK sattemnet hsa a ysntatcica lerrro.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Dro pthed ataabse ilnk nad rcereaet itu sin gvaldi sytnax.S ee hte SLQ Lagnuag eRefreenc eManaul fro moer inofrmaiton baoutt he ocnnetc stirng oprtino oft he RCEAT EDATBAASEL INKs tatmeent.
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.