Space Allocated For Long Raw??

From: greg teets <teetshd_at_ucbeh.san.uc.edu>
Date: 1997/03/20
Message-ID: <3331c375.624881@news.ececs.uc.edu>#1/1

While an element of type long raw can hold up to 2GB, how much space will Oracle allocate to a table in which the long raw items are NULL?

For example:

table test_blob

columns:
blob_id int not null
blob_item long raw can be null

Let's say that there are 15 rows. How much space would Oracle allocate for this table when it is created? Does Oracle actually use a pointer to handle this?

Thanks in advance
Greg in Cincinnati Received on Thu Mar 20 1997 - 00:00:00 CST