RE: nls_length_semantics showing different Values!

From: Hallas, John (EXP N-ARM) <john.hallas_at_lmco.com>
Date: Thu, 09 Aug 2007 14:44:00 +0100
Message-id: <4C623E38629BDA469E90D1FF271309E9106FF44E@emss51m09.uk.lmco.com>

Metalink Notes 144880.1 and 241047.1 explain all.

From: edwin devadanam [mailto:edwin_kodamala_at_yahoo.com] Sent: 09 August 2007 13:47
To: Hallas, John (EXP N-ARM)
Cc: oracle-l_at_freelists.org
Subject: RE: nls_length_semantics showing different Values!

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

<http://us.rd.yahoo.com/evt=48220/*http://tv.yahoo.com/> on Yahoo! TV.

Building a website is a piece of cake.
Yahoo! Small Business gives you all the tools to get online. <http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhos ting/?p=PASSPORTPLUS>

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

Received on Thu Aug 09 2007 - 08:44:00 CDT