Re: update from select not commited

jingc3_at_yahoo.com wrote in message news:<acd69dfb.0201291533.72b1916a_at_posting.google.com>...
> 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

1 No, there is no limit
2 Hence there is no parameter
If you didn't receive an error the problem must be in your sql or in your data. Are these 'key' columns NULL allowed by any chance?

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed Jan 30 2002 - 09:31:45 CET