Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update a table with no logging?
"Jim" <no-spam_at_no-spam.org> wrote in message
news:opp2gt8afjko15ou0npd53u6ceijecs6h4_at_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.
>
Truncate table <table_name>
Won't log anything, and will commit automatically as it is DDL, not DML.
If you want to get rid of your data fast: perfect option.
BTW : AFAIK replace in Sql*loader does *exactly* the same.
Hth,
Sybrand Bakker, Oracle DBA Received on Tue May 15 2001 - 14:52:20 CDT