default length for DATE datatype

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 14 May 2008 14:21:32 -0500
Message-ID: <BLU108-W3016E5FBBFB6BCEA7A4B7697CE0@phx.gbl>

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            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_IDTABLE            EMAIL_ADDRESSTABLE            START_DATE                                                  27TABLE            MARKETING_PREFERENCES_FLAGTABLE            END_DATE                                                      27TABLE            SOURCE
 

thanks.  

---

With Windows Live for mobile, your contacts travel with you. http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_Refresh_mobile_052008

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

Received on Wed May 14 2008 - 14:21:32 CDT