RE: default length for DATE datatype

Is this having an affect on your database's performance or is this purely academic?    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Thursday, May 15, 2008 8:15 AM
To: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org Subject: RE: default length for DATE datatype  

There is a default value specfied in the ddl script. That what it is. But it is the same default value. And the char sets are the same. thanks.  

Subject: RE: default length for DATE datatype Date: Thu, 15 May 2008 08:08:05 -0400
From: Thomas.Mercadante_at_labor.state.ny.us To: joe_dba_at_hotmail.com; oracle-l_at_freelists.org

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>  

Get Free (PRODUCT) RED(tm) Emoticons, Winks and Display Pics. Check it out!
<http://joinred.spaces.live.com?ocid=TXT_HMTG_prodredemoticons_052008>

>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1

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