nls_length_semantics -- How do I change it?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: nls_length_semantics -- How do I change it?

  1. #1
    Join Date
    May 2001
    Posts
    285

    nls_length_semantics -- How do I change it?

    Oracle doc said we should define this in init.ora file, but I can't find it in my pfile. When I select this parameter from nls_database_parameters, it is defined to 'byte' which is the default. How do I change it? Also, since I didn't find it in pfile, could it be in spfile instead? How can I find that out?

    Thanks!

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Do this from sqlplus..
    show parameter nls_length
    alter system set nls_length_semantics=your_value scope=both;
    show parameter nls_length

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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