Re: Column width different in view

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: Dennis Williams <oracledba.williams@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 15 Jul 2011 18:09:25 -0400

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@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: