Re: Rollback and Large Transactions

fastnet wrote:
>
> Hey all i have a quick question for you...
>
> Basically we are running into an issue with a rollback segment filling up on
> a large bulk transaction (batch job in the middle of the night that is
> basically a insert into table select * deal).
>
> Basically Im wondering is there a way to run this job without using a
> rollback segment at all??. In this instance we dont need it cause we
> truncate the destination initially.
>
> tia
>
> me

Try

1. alter table xxx nologging
2. insert /*+ APPEND */ into xxx select * from yyy

and have a read on direct-load insert and parallel dml.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse