Re: Massively update but small disk space

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/11/19
Message-ID: <64u5cg$ius_at_bgtnsc02.worldnet.att.net>#1/1

If you have enough disk space to create another table like 'DATA', you could try this:

CREATE TABLE DATA1
UNRECOVERABLE
AS SELECT ...,VAL/2,...
FROM DATA; Then 'drop table DATA cascade constraints' and 'rename DATA1 to DATA'. You will have to re-create any indexes, constraints, triggers, etc. on the new DATA table.

Hope this helps.

Michael Serbanescu

---

On Tue, 18 Nov 1997 09:36:56 +0100, Marc Brevet Lepreux <mbl_at_concept.fr> wrote:

>Hello,
>I search a solution to update one value in big table.
>I have a table 'DATA' (1150000 rows) with a column VAL (NUMBER), i need
>to divide by 2 all VAL .
>It's not possible for a technical Hardware reason to increase Rollback
>Segment.
>If you have a solution in PLSQL or others, thanks a lot.
>
>
>
Received on Wed Nov 19 1997 - 00:00:00 CET