can i set lang and territory of init after created DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: can i set lang and territory of init after created DB

  1. #1
    Join Date
    Aug 2004
    Posts
    14

    can i set lang and territory of init after created DB

    To Gurus,

    After i clone DB or created DB already. It seem like i set wrong value of parameter "nls_lang" and "nls_territory" The point is...can i alter the to new value permanently!!! if so, how ??

    Thanks in Advance

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    If you have 9i or 10g with an spfile then do this.
    Code:
    ALTER SYSTEM SET nls_lang='AMERICA'
                     SCOPE=BOTH;
    
    ALTER SYSTEM SET nls_territory='AMERICA'
                     SCOPE=BOTH;
    Otherwise find your pfile and change it there. It should be in $ORACLE_BASE/admin/sidname/pfile

    or if you are running Windows contrary to Jeff's good guidance then it would be:
    $ORACLE_BASE\admin\sidname\pfile

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    NLS_LANG is not an initialisation parameter, it's only enviroment variable. So you can't set it for the database, neither with "ALTER SYSTEM SET ..." statement nor by editing init file. You can set it only on your OS level.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Aug 2004
    Posts
    14

    How could i set it by OS

    How could I do that??


    Originally posted by jmodic
    NLS_LANG is not an initialisation parameter, it's only enviroment variable. So you can't set it for the database, neither with "ALTER SYSTEM SET ..." statement nor by editing init file. You can set it only on your OS level.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Depends on your OS. Ask your sysadmin to axplain you about enviroment variables....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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