In memory where? Space is reserved in DB blocks (formerly via PCTFREE, now via ASSM) for operations that increase the storage requirements of the block--such as updating a character string to a longer string, or supplying a value in a column that formerly contained none. On 9/27/05, ryan_gaffuri@xxxxxxxxxxx <ryan_gaffuri@xxxxxxxxxxx> wrote: > > Someone at work told me the following. Having trouble confirming it in the > docs. > If you have a table with a nullable varchar column. If the field is left > null no space will be taken up in the database. However, space will be > reserved in memory for the column. Is this correct? > -- Paul Baumgartel paul.baumgartel@xxxxxxxxxxxx