Re: Column width different in view

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Fri, 15 Jul 2011 18:09:25 -0400
Message-ID: <038009af-2195-4084-bc30-a9ad78f2556e_at_blur>

What is nls length semantics set to? What is character set?

Sent from my Motorola ATRIX™ 4G on AT&T

-----Original message-----

From: Dennis Williams <oracledba.williams_at_gmail.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Fri, Jul 15, 2011 22:04:24 GMT+00:00 Subject: Column width different in view

List,

We have a situation where a view is created on a table. The underlying column is defined as CHAR(18). We are doing this to a number of Oracle 10.2.0.4 databases. On all of them the view creates just fine. But on one database the column in the view is created as CHAR(54). Has anyone encountered anything like this?

Thank you,
Dennis Williams
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 15 2011 - 17:09:25 CDT