Re: dml without redo

Manoj,

> I want to fire an update stmt without genereating redo.
> The table has large volumn of data and I've update only column
> conditionally.

I don't see where you received a reply to your question. Hopefully this reply doesn't reach you too late.

I do not believe you can update an Oracle table without generating redo. For this reason, many data warehouse applications are written to perfom "insert-only" processing.

The key part is in your statement where you say you only update a column conditionally. If you can use the WHERE clause to minimize the number of rows that are updated, and only update the single column, while this won't eliminate your redo, it will minimize it.

Cheers,
Dennis Williams

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