RE: nls_length_semantics showing different Values!

From: edwin devadanam <edwin_kodamala_at_yahoo.com>
Date: Thu, 9 Aug 2007 05:46:36 -0700 (PDT)
Message-ID: <43295.98506.qm@web52002.mail.re2.yahoo.com>

 

  Its an upgraded instance from 8.1.7.4 to 10.2.0.2 using exp/imp method.        

  -Edwin.K

"Hallas, John (EXP N-ARM)" <john.hallas_at_lmco.com> wrote:

      I will have to refresh my memory but I am certain that one remains in the state it was when the database was created and the other changes based on init.ora settings     

---

  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of edwin devadanam Sent: 09 August 2007 13:04
To: oracle-l_at_freelists.org
Subject: nls_length_semantics showing different Values!   

  Hi,    

  O/S is HP-UX        

  1)select * from nls_database_parameters; NLS_LENGTH_SEMANTICS CHAR       2)select * from V$nls_parameters;
NLS_LENGTH_SEMANTICS BYTE       3)In init.ora it is
  nls_length_semantics = BYTE        

  ours is 10.2.0.2        

  why is this difference?        

  Regards,
Edwin.K     

---

  Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.        

---

Building a website is a piece of cake.
Yahoo! Small Business gives you all the tools to get online.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 09 2007 - 07:46:36 CDT