Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Update a table with no logging?

Re: Update a table with no logging?

From: Jim <no-spam_at_no-spam.org>
Date: Tue, 15 May 2001 13:43:32 -0700
Message-ID: <f653gto8p2ssa6nmpjg71mhchbl4qj1joa@4ax.com>

Thank you Sybrand.

On Tue, 15 May 2001 21:52:20 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>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 - 15:43:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US