tag:blogger.com,1999:blog-8884584404576003487.post3869162034486577971..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: ORA-12705: Cannot access NLS data files or invalid environment specifiedoraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8884584404576003487.post-51161379173510963432010-09-30T09:52:13.106-04:002010-09-30T09:52:13.106-04:00Thank you! I read a similar suggestion on other fo...Thank you! I read a similar suggestion on other forums, but I have multiple ORACLE_HOMES and in my registry I was attempting to edit the NLS_LANG key in the specific home I was working with, which didn't work. Had to go to the top-level key as you suggest.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-27879991203600241092010-07-06T01:28:45.992-04:002010-07-06T01:28:45.992-04:00Fortunately we aren't creating or modifying da...Fortunately we aren't creating or modifying data with this tool...merely gathering the metadata for specific tables.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-35591166821242483242010-07-06T00:31:10.456-04:002010-07-06T00:31:10.456-04:00If you didn't know that, perhaps you didn'...If you didn't know that, perhaps you didn't know that using the 7 bit doesn't prevent you from putting in 8 bit data with several tools. Then an exp/imp to the proper bittage loses bits...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-70879565293342670232010-07-01T09:17:01.629-04:002010-07-01T09:17:01.629-04:00I did not know that.
Admittedly, this post was a ...I did not know that.<br /><br />Admittedly, this post was a <i>terrible</i> way to go about it...just unsetting/setting something without understanding the downstream consequences <i><b>is not</b></i> a very good practice.<br /><br />Thanks for the tip Kurt.<br /><br />chetoraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-88823026391621186492010-07-01T04:48:13.051-04:002010-07-01T04:48:13.051-04:00You do know that by unsetting nls_lang you default...You do know that by unsetting nls_lang you default to the US7ASCII codepage ? And thus, if you import data with an 8bit codepage, you can end up with data loss.<br /><br />Instead of unsetting NLS_LANG, setting ORA_NLS10 to %ORACLE_HOME%/nls/data in the registry might have been a better choice...kurthttp://www.ora600.benoreply@blogger.com