Moving 350 meg lob takes nearly 4 gigs

 Oracle 9.2.0.4; Solaris 9
I have a table (CONTENT) with a lob. The table was 3.7 gig, the lob 385M (and the lob's index 5m)

I moved the CONTENT table from DMT to LMT. Then I tried to move the lob.

The LOB move took over 1 hour and consumed nearly 4 gigs of space in temporary segments. It's now 345 megs in the new LMT tablespace.

BEFORE THE MOVE (in DMT tablespace)

                                     Ext Init
Object                         Size  nts Ext
---------------------------- ------ ---- -----
SYS_IL0000397843C00006$$        5M     1 5M
SYS_LOB0000397843C00006$$     385M    57 9M
CONTENT                      3718M   285 10M

DURING THE MOVE:

10.33548                    15M      15  15M
10.24218                   305M      81  300M
10.33932                  3264M     219  8M
CONTENT                   3520M     223  8M

AFTER THE MOVE (in LMT tablesapce)

SYS_LOB0000397843C00006$$ 345M 86 200M

SYS_IL0000397843C00006$$      10M    10 10M
CONTENT                     3520M   223 8M

The LMT tblspace is autoallocate. (I know not everyone here is a big autoallocate fan. But I would not expect that to be the issue.)

   Create tablespace arclmt datafile ' ' extent management local    autoallocate logging online segment space management auto;

Here's the command I used to move the lob:

   alter table arcdb.content move lob(measures) store as (tablespace arclmt);

Is this expected?? I can't see why it would take 4 gigs to create a 345 meg object.

Thanks!

--
http://www.freelists.org/webpage/oracle-l