Re: Materialized view column length is 3 times

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Mar 2005 13:27:10 -0800
Message-ID: <1110835630.130312.172230@f14g2000cwb.googlegroups.com>

No oracle version again!

Let me guess:

You created the table on a multibyte variable length characterset database.
You then specified column lengths using char length semantics.
You are using user_tab_columns.data_length to determine the column length. (Third party tools like pl/sql developer might not understand char length semantics)

Here is an example (sorry about the formatting):

ORA92> select COLUMN_NAME, DATA_TYPE, DATA_LENGTH from user_tab_columns where table_name = 'MYTAB';

COLUMN_NAME                    DATA_TYPE

DATA_LENGTH

------------------------------ ------------------------------
-----------
A                              VARCHAR2
30
B                              VARCHAR2

ORA92> desc mytab
Name
Null? Type

-------------------------------------------- A VARCHAR2(10 CHAR) B VARCHAR2(20 CHAR)

ORA92> select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, CHAR_LENGTH from user_tab_columns where table_name = 'MYTAB';

COLUMN_NAME                    DATA_TYPE

DATA_LENGTH CHAR_LENGTH

------------------------------ ------------------------------
----------- -----------
A                              VARCHAR2
30          10
B                              VARCHAR2
60          20

Anurag Received on Mon Mar 14 2005 - 15:27:10 CST