RE: default length for DATE datatype

Are the character sets the same on both databases?

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Wednesday, May 14, 2008 3:22 PM
To: oracle-l_at_freelists.org
Subject: default length for DATE datatype

How can the same table in two different databases have a different DEFAULT_LENGTH for the DATE datatype? One database is dev and the other is UAT. Both databases are on the same server and same oracle home 10.2.0.3.0 EE.    

> select table_name, column_name , default_length from user_tab_columns
where table_name ='TABLE';

TABLE_NAME                     COLUMN_NAME

------------------------------ ------------------------------
--------------
TABLE            PARTNER_ID
TABLE            EMAIL_ADDRESS
TABLE            START_DATE
22
TABLE            MARKETING_PREFERENCES_FLAG
TABLE            END_DATE
22
TABLE            SOURCE

> select table_name, column_name , default_length from user_tab_columns
where table_name ='TABLE';

TABLE_NAME                     COLUMN_NAME

------------------------------ ------------------------------
--------------
TABLE            PARTNER_ID
TABLE            EMAIL_ADDRESS
TABLE            START_DATE
27
TABLE            MARKETING_PREFERENCES_FLAG
TABLE            END_DATE
27
TABLE            SOURCE
 

thanks.  

With Windows Live for mobile, your contacts travel with you. Connect on the go.
<http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_Refre sh_mobile_052008>

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