RE: Please a parameter to disable undo, like _disable_logging

create table as nologging
as your indexes when your done all at the same time(open a session for each index). 10 million rows is nothing unless your talking about monstrous column sizes and getting into masses amounts of data.

the slowdown from inserts comes from indexes.

• Original message --------------

> /*+ append */ disables redo, not undo (as does =5Fdisable=5Flogging).
>
> Array/bulk inserts will reduce the amount of undo you generate, so this =
> method will help. But you can't avoid undo altogether.
>
> At least you're not updating or deleting the 10,000,000 rows.
>
> John
>
>

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