Re: Schema Design Question ( Other Gurus Please jump on)
From: Bilal Nabi <bilal_at_stglabs.8m.com>
Date: 25 Jan 2002 21:20:52 -0800
Message-ID: <7b4a461a.0201252120.6246320e_at_posting.google.com>
Date: 25 Jan 2002 21:20:52 -0800
Message-ID: <7b4a461a.0201252120.6246320e_at_posting.google.com>
Dear Raghu,
Varchar2 column does not keep a space of 1000 characters. It maybe
1000 when u define but if u keep a single character it will reserve
only one character.
For Clob's Oracle 8 and above does not store the actual value in the table rather they keep a pointer.
With the inittrans,maxtrans,pctfree,pctused u can optimize the space
usage what to talk of a table but also in a block.
Bye,
Bilal
Received on Sat Jan 26 2002 - 06:20:52 CET