changeing NLS_LANG on personal oracle on win98
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: changeing NLS_LANG on personal oracle on win98

  1. #1
    Join Date
    Jul 2000
    Posts
    243
    Hi all

    I installed personal oracle 8i on win98. My win98 is hebrow enable, and my oracle is in hebrow. I tryed to change the nls_lang to AMERICAN_AMERICA.IW8ISO8859P8 but no good(as i thought it would be, but i had to try)

    Can any one out there tell me how to convert my oracle to English? do i need to re-install it, or gust change a few parameters

    thanks

  2. #2
    Join Date
    Jun 2000
    Posts
    179
    For the database , you will need to create a new database with the new character set , you can not change a database character set after its created.

    If you have work on the old database , just make and export dump file and re import it to the New one.

    Also get to the windows registry ( Software / Oracle section ) select NLS_LANG key , chang it to the character set you want then restart windows , you should work correctly Now.
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width