Hi.
I want to update a table based on data in another
table. Something like:
update table1 a set f1 =
(select f2
from table2
where table2.f3 = table1.f3
and table2.f4 = table1.f4);
this seems to work, but generates a lot of redo logs.
So I tried to add NOLOGGING. Alas, seems like
NOLOGGING
NOLOGGING does not work on update, period. has nothing to do with
aliases.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 3:48 PM
Hi.
I want to update a table based on data
Your update is updating all rows in table1. Is that
what you want ?
nologging only works with direct path insert, not with
update.
--- Gurelei [EMAIL PROTECTED] a écrit : Hi.
I want to update a table based on data in another
table. Something like:
update table1 a set f1 =
(select f2