Re: Large updates on Oracle 8

Presumably your working environment is too small to do a simple 'update all rows' as a single transaction; and other restrictions make the 'create new table unrecoverable as select from old_table with changes' unworkable. Similarly I presume that rigging your system for parallel DML (in this case, single transaction parallel updates) is ruled out.

If you have to follow the route of sectioning the table, you might want to look at my website which suggests (for Oracle 7) a strategy for updating very large tables by rowid ranges. The changes needed to handle an Oracle 8 table are small.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

rob_bell_at_csi.com wrote in message <7k3joh$oh$1_at_nnrp1.deja.com>...
>Hello,
>
>I am researching the best way to perform large updates on a single table
>in an Oracle 8 database. I've found some information in the archives of
>this group, but most of the solutions similar to my situation are quite
>(relatively) old. I would appreciate anybody's ideas as to the best way
>to perform the type of update described below. I'm especially
>interested to see if Oracle 8 has any built-in features to aid this
>process (new directives, commands, PL/SQL, etc).
Received on Mon Jun 14 1999 - 15:41:45 CDT