RE: default length for DATE datatype
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 May 2008 07:14:59 -0500
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 datatypeDate: Thu, 15 May 2008 08:08:05
-0400From: Thomas.Mercadante@xxxxxxxxxxxxxxxxxxx: 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 SmithSent: Wednesday, May 14, 2008 3:22 PMTo:
oracle-l@xxxxxxxxxxxxxxxxxxxx: default length for DATE datatype
How can the same table in two different databases have a
differentDEFAULT_LENGTH for the DATE datatype? One database is dev and the
otheris 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_IDTABLE
EMAIL_ADDRESSTABLE START_DATE
22TABLE MARKETING_PREFERENCES_FLAGTABLE
END_DATE 22TABLE
SOURCE6 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_IDTABLE
EMAIL_ADDRESSTABLE START_DATE
27TABLE MARKETING_PREFERENCES_FLAGTABLE
END_DATE 27TABLE
SOURCE thanks.
With Windows Live for mobile, your contacts travel with you. Connect on the go.
_________________________________________________________________
Get Free (PRODUCT) RED™ Emoticons, Winks and Display Pics.
http://joinred.spaces.live.com?ocid=TXT_HMTG_prodredemoticons_052008
Other related posts:
