Re: Update a table with no logging?

From: Jim <no-spam_at_no-spam.org>
Date: Tue, 15 May 2001 10:34:05 -0700
Message-ID: <opp2gt8afjko15ou0npd53u6ceijecs6h4@4ax.com>

Thank you all for your suggestions. Looks like the /*+APPEND*/ hint is something for us to carefully review for our update commands.

As an aside, could we not also use sqlldr with "append" to add rows to an existing table for those cases that do not require an "update" command?

Also, is there an equivalent means to delete rows from a table without logging the deletes?

Thank you again for your help.

On Mon, 14 May 2001 10:17:10 -0700, Jim <no-spam_at_no-spam.org> wrote:

>We have some report-only tables to which we will need to add rows
>every month. Is there a way to add rows to a table and not log the
>added rows? The easiest way for us to recover from a problem would be
>to just re-load the tables.
Received on Tue May 15 2001 - 12:34:05 CDT