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: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 15 May 2001 20:06:44 +1000
Message-ID: <3b00ffbe@news.iprimus.com.au>

Nonsense. That STILL won't stop logging of normal DML.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"wayne" <no_at_email.please.com> wrote in message
news:9dp8rt$8hu_at_dispatch.concentric.net...

> > 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.
>
> Here's one way: Create a new tablespace for these tables and disable
> logging on the tablespace.
>
>
Received on Tue May 15 2001 - 05:06:44 CDT

Original text of this message

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