Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update a table with no logging?
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