I got out of memory ORA-04030 when I move table with lob segments

Hi,

I understand that cause an event "direct path read", and for that Oracle will use too much PGA for such a statement!

but my question why so! when I have 16G free memory, and the move lob is less than 400M.

here a description about the case!

SQL> desc intlbi_prod.promo_log
 Name                                                              Null?    Type
 ----------------------------------------------------------------- -------- --------------------------------------------
 ID                                                                NOT NULL NUMBER
 XML_IN                                                            NOT NULL PUBLIC.XMLTYPE STORAGE BINARY
 BEW_OUT                                                                    PUBLIC.XMLTYPE STORAGE BINARY
 REDRU_OUT                                                                  PUBLIC.XMLTYPE STORAGE BINARY
 ERRORCODE                                                         NOT NULL NUMBER
 START_DATZT                                                       NOT NULL DATE
 END_DATZT                                                                  DATE

SQL> select s.bytes / 1024 / 1024 size_mb,
       l.table_name,
   and l.owner = s.owner^J   and l.owner = 'INTLBI_PROD'
 where l.se   and l.table_name='PROMO_LOG'
 order by 1;
       s.segment_name,
       l.column_name
  from dba_segments s, dbA_lobs l
 where l.segment_name = s.segment_name
   and l.owner = s.owner
   and l.owner = 'INTLBI_PROD'
   and l.table_name='PROMO_LOG'
 10   order by 1;

   SIZE_MB TABLE_NAME           SEGMENT_NAME                             COLUMN_NAME
---------- -------------------- ---------------------------------------- --------------------
       339 PROMO_LOG            SYS_LOB0010172017C00003$$                SYS_NC00003$
      1014 PROMO_LOG            SYS_LOB0010172017C00005$$                SYS_NC00005$