Re: dml without redo
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: manoj.gurnani@xxxxxxxxxxxxx
- Date: Mon, 7 Nov 2005 09:54:32 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
