Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9ENuac30436 for ; Tue, 14 Oct 2003 18:56:36 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9ENuac30431 for ; Tue, 14 Oct 2003 18:56:36 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id h9ELA0Vh006435 for ; Tue, 14 Oct 2003 14:11:40 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id h9EKoQRx004376 for oracle-l@orafaq.net; Tue, 14 Oct 2003 13:50:26 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D3160; Tue, 14 Oct 2003 13:49:25 -0800 Message-ID: Date: Tue, 14 Oct 2003 13:49:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Igor Neyman" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Igor Neyman" Subject: RE: space taken up by number data types Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005E_01C39272.C47B2E40" ------=_NextPart_000_005E_01C39272.C47B2E40 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Yes, T.Kyte is still right :-) Space is not reserved for NUMBER type, it is "variable length" column. Amount of space occupied depends on particular number, which is stored in the column. Igor Neyman, OCP DBA ineyman@perceptron.com -----Original Message----- Ryan Sent: Tuesday, October 14, 2003 4:10 PM To: Multiple recipients of list ORACLE-L I could have swarn I read that Precision with number data types effects how much space is reserved in the database. So number(38) and number(3) reserve different amounts of space. Here is a link from Tom Kyte in 1998 saying the opposite. Is what he says still true? http://groups.google.com/groups?hl=en &lr=&ie=UTF-8&oe=UTF-8&threadm=355e25d0.17874392%40192.86.155.100&rnum=1 &prev=/groups%3Fas_q%3Dnumber%2520datatype%2520storage%26safe%3Dimages%2 6ie%3DUTF-8%26oe%3DUTF-8%26as_ugroup%3D*oracle*%26lr%3D%26num%3D50%26hl% 3Den ------=_NextPart_000_005E_01C39272.C47B2E40 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Yes, T.Kyte is still right = J

Space is not reserved for NUMBER = type, it is “variable length” column.  Amount of space occupied = depends on particular number, which is stored in the column.

 

Igor Neyman, OCP = DBA

ineyman@perceptron.com

 

 

-----Original = Message-----
From: = ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On = Behalf Of Ryan
Sent: Tuesday, October = 14, 2003 4:10 PM
To: Multiple recipients = of list ORACLE-L
Subject: space taken up = by number data types

 

I could have swarn I read = that Precision with number data types effects how much space is reserved in = the database. So number(38) and number(3) reserve different amounts of = space.

 

Here is a link from Tom = Kyte in 1998 saying the opposite. Is what he says still true?

 

------=_NextPart_000_005E_01C39272.C47B2E40-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: ineyman@perceptron.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).