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 -> Stopping archiving of a single table

Stopping archiving of a single table

From: Peter Marusek <pmaruse_at_hargray.com>
Date: 1996/12/19
Message-ID: <59ca7j$15r@mel.hargray.com>#1/1

Does anyone know of a what, short of stopping all archiving, then restarting, of just stopping the archiving of a single table. We have a temp table that is just huge and eating up many many megs of log files, which are useless to us if we have to recover. I saw a way of turning off recover for CREATE TABLE, but it says it does not turn off recovery for updates. It is such a pain in the butt to have to run this program stand alone offshift with archiving turned off, and then remember to have it turned on again. Any ideas? We are running AIX 3.2.5 on a RS/6000. cheers
Peter Marusek
Beaufort County SC Data Processing Received on Thu Dec 19 1996 - 00:00:00 CST

Original text of this message

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