DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001

    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?


  2. #2
    Join Date
    Feb 2000
    Do this from sqlplus..
    show parameter nls_length
    alter system set nls_length_semantics=your_value scope=both;
    show parameter nls_length

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.