Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 32457 invoked from network); 14 May 2008 15:00:08 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 14 May 2008 15:00:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 24B8F85114F; Wed, 14 May 2008 15:58:09 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31835-09-3; Wed, 14 May 2008 15:58:08 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F3978511DB; Wed, 14 May 2008 15:58:08 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 14 May 2008 15:19:35 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 12520850F4B for ; Wed, 14 May 2008 15:19:35 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26139-10 for ; Wed, 14 May 2008 15:19:34 -0400 (EDT) Received: from blu0-omc4-s31.blu0.hotmail.com (blu0-omc4-s31.blu0.hotmail.com [65.55.111.170]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A430C850D7A for ; Wed, 14 May 2008 15:19:34 -0400 (EDT) Received: from BLU108-W30 ([65.55.111.135]) by blu0-omc4-s31.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 14 May 2008 12:21:32 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_fd78e6b8-c31d-4b9b-bedd-b89bc04cc5ab_" X-Originating-IP: [66.236.147.253] From: Joe Smith To: Subject: default length for DATE datatype Date: Wed, 14 May 2008 14:21:32 -0500 MIME-Version: 1.0 X-OriginalArrivalTime: 14 May 2008 19:21:32.0376 (UTC) FILETIME=[B7B5E580:01C8B5F7] X-archive-position: 8077 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: joe_dba@hotmail.com Precedence: normal Reply-to: joe_dba@hotmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --_fd78e6b8-c31d-4b9b-bedd-b89bc04cc5ab_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can the same table in two different databases have a differentDEFAULT_L= ENGTH for the DATE datatype? One database is dev and the otheris UAT. Bot= h databases are on the same server and same oracle home 10.2.0.3.0 EE. =20 =20 > select table_name, column_name , default_length from user_tab_columns whe= re table_name =3D'TABLE'; TABLE_NAME COLUMN_NAME DEFAULT_LENGT= H------------------------------ ------------------------------ ------------= --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 whe= re table_name =3D'TABLE'; TABLE_NAME COLUMN_NAME DEFAULT_LENGT= H------------------------------ ------------------------------ ------------= --TABLE PARTNER_IDTABLE EMAIL_ADDRESSTABLE = START_DATE 27TABLE = MARKETING_PREFERENCES_FLAGTABLE END_DATE = 27TABLE SOURCE =20 thanks. =20 _________________________________________________________________ With Windows Live for mobile, your contacts travel with you. http://www.windowslive.com/mobile/overview.html?ocid=3DTXT_TAGLM_WL_Refresh= _mobile_052008= --_fd78e6b8-c31d-4b9b-bedd-b89bc04cc5ab_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can the same table in two different databases have a different
DEFAU= LT_LENGTH  for the DATE datatype? One database is dev and the otheris UAT.  Both databases are on the same server and same oracle home 1= 0.2.0.3.0 EE.
 
 

> select table_name, column_name , default_length from user_tab_colu= mns where table_name =3D'TABLE';
TABLE_NAME           = ;          COLUMN_NAME &n= bsp;            = ;      DEFAULT_LENGTH
-------------------------= ----- ------------------------------ --------------
TABLE  &nb= sp;         PARTNER_ID
TABLE&nbs= p;           EMAIL_ADDRES= S
TABLE           = ; START_DATE          &nb= sp;            =             &nb= sp;            22TABLE            MA= RKETING_PREFERENCES_FLAG
TABLE       =      END_DATE       =             &nb= sp;            =             &nb= sp;       22
TABLE   &= nbsp;        SOURCE
6 rows selected.

> select table_name, column_name , default_length from user_tab_colu= mns where table_name =3D'TABLE';
TABLE_NAME           = ;          COLUMN_NAME &n= bsp;            = ;      DEFAULT_LENGTH
-------------------------= ----- ------------------------------ --------------
TABLE  &nb= sp;         PARTNER_ID
TABLE&nbs= p;           EMAIL_ADDRES= S
TABLE           = ; START_DATE          &nb= sp;            =             &nb= sp;            =   27
TABLE         &nb= sp;  MARKETING_PREFERENCES_FLAG
TABLE     =        END_DATE     =             &nb= sp;            =             &nb= sp;           27
TABLE=             SOURCE  
thanks.

 

With Windows Live for mobile, your contacts trave= l with you. Connect on the go. = --_fd78e6b8-c31d-4b9b-bedd-b89bc04cc5ab_-- -- http://www.freelists.org/webpage/oracle-l