RE: default length for DATE datatype

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 May 2008 08:08:05 -0400

Are the character sets the same on both databases?

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith
Sent: Wednesday, May 14, 2008 3:22 PM
To: oracle-l@xxxxxxxxxxxxx
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
DEFAULT_LENGTH
------------------------------ ------------------------------
--------------
TABLE            PARTNER_ID
TABLE            EMAIL_ADDRESS
TABLE            START_DATE
22
TABLE            MARKETING_PREFERENCES_FLAG
TABLE            END_DATE
22
TABLE            SOURCE
6 rows selected.

> select table_name, column_name , default_length from user_tab_columns
where table_name ='TABLE';
TABLE_NAME                     COLUMN_NAME
DEFAULT_LENGTH
------------------------------ ------------------------------
--------------
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>  

Other related posts: