RE: default length for DATE datatype
- From: "Brady, Mark" <Mark.Brady@xxxxxxxxxxxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>, "Mercadante, Thomas F (LABOR)" <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 May 2008 09:17:52 -0400
Is this having an affect on your database's performance or is this
purely academic?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith
Sent: Thursday, May 15, 2008 8:15 AM
To: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
To: joe_dba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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>
________________________________
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
Other related posts:
