update from select not commited

Hi,

I have a sql like this:

UPDATE TABLE1 SET (COL1, COL2, COL3, COL4) = (SELECT COL1, COL2, COL3, COL4 FROM TABLE2 WHERE TABLE2.KEY = TABLE1.KEY) There should be about 9,598 records to be updated in the TABLE1. However, only about 3,064 records were updated.

My questions are:
1. Is this many rows out of limit of capability to update based on select?
2. Is there any parameter in Oracle configuration file to increase this limit? This is very important to me and it is the fast solution to my problem.

Thanks!!

Jing Received on Wed Jan 30 2002 - 00:33:22 CET