Re: Storage Allocation Question

Dereck L. Dietz wrote:
> Oracle 10g R 10.2.0.3, Windows 2003 Server
>
> I know if I have a VARCHAR2(50) column and I update it from a 15 character
> string to 25 character string that I'll use more storage space in the data
> blocks.
>
> If I have a NUMERIC(10) column and I update it from a 0 value to a non-zero
> value will that use more storage space or will the allocation for it being
> NUMERIC(10) already have the storage space allocated?
>
> Thanks.
>
> P.S.: What is it with all these MI5 posts?
>
>

Numbers are stored as a mantissa and exponent. If the size of those do not change, then your storage requirements do not change.

Metalink Note:143256.1 has some more details which may be of interest to you.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com