Storage allocation for LOB and LONG datatypes

From: Hillman, Alex <Alex.Hillman_at_usmint.treas.gov>
Date: Mon, 25 Jun 2001 13:24:10 -0700
Message-ID: <F001.003373D2.20010625133535@fatcity.com>

I have several questions answers for wich I couldn't find in FM (not that I tried too hard :-) ).

If LONG or LOB takes more than 1 block - how part of the last block left free is used? Can it be used to store part of another LONG or LOB which more thatn this free peace? I think not but not tested.
What happens if LONG or LOB is updated? (again longer than 1 block). Which blocks are moved? Chained or migrated?
How rollback and redo generated for update? And how much?
Anything else interesting that I did not mention?

Alex Hillman
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hillman, Alex
INET: Alex.Hillman_at_usmint.treas.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_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). Received on Mon Jun 25 2001 - 15:24:10 CDT