On 6/23/06, Leng Kaing <Leng.Kaing_at_hsntech.com> wrote:
>
> During imports, depending on the size of your clob column, you may be
> able to get away with COMMIT=N. I've found this to be much faster than
> COMMIT=Y. However, it means that you must have a LARGE undo retention and
> tablespace, otherwise your import will fail.
>
Really large undo is not normally generated by INSERTS,
as Oracle only needs a rowid to undo the insert.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 12 2006 - 15:29:59 CDT
