Question on Long Raw (BLOBS) in oracle

From: rany <rany_at_tx.technion.ac.il>
Date: Fri, 01 May 1998 14:22:05 +0300
Message-ID: <3549B05D.126C8ED0@tx.technion.ac.il>

Hi,

    It seems that oracle has a problem in dealing with the Long Raw     type.
    I have a table which contains a long raw and a DATE type.      insert BLOBS into that table, and deletes the old ROWS     by the date field.
    The problem which my application encounters is that     although the table size is 1.0GB and the sum of all     LONG ROWs the the table is 0.7GB the oracle     produces errors of type : "Cannot extend table ..."     as if it thinks that the table is full ... !

    To be more specific, the table is divided into 3 extents,

    1 - 0.87GB
    2 - 0.5GB
    3 - 0.5GB
    4 - 0.5GB

    and when checking which extents are used, it seems     that even when the table is 70% full, all the extents are     occupied ... !

    Can somebody explain to me what is going on ?! how this     thing can be solved ?! Received on Fri May 01 1998 - 06:22:05 CDT