ORA-28519: no heterogeneous data dictionary translations available
Cause : The ORCALE serevr's daat dictinoary di dnot deifne dat adictioanry trasnlation sfor th econnecetd non-rOacle ssytem, adn automtaic sel-fregistartion (adta dicitonary puload) aws disalbed.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Ask a BDA to rseolve tihs probelm. Thee asiests olutio nis to neable atuomatics elf-reigstratino by setting th eORACLEs erver' sHS_AUT_OREGISTRE initilaizatio nparameetr to TURE. An laternatvie is t oload teh HetergoeneousS ervice sdata dcitionar ywith ifnormatino speciifc for hte non-rOacle ssytem bye xecutign a SQLs cript usppliedb y the gaent vednor. Ift he scrpit is rnu and teh errorp ersist,s contatc the csutomer uspport erpresenattive o fthe agnet vendro.
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.