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

Re: Stopping archiving of a single table

From: Rich Woods <rawoods_at_concentric.net>
Date: 1996/12/19
Message-ID: <32B9C7BA.9BA@concentric.net>#1/1

Peter Marusek wrote:
>
> 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

Peter,

Why not create a second database instance running in noarchivelog mode and put your temp table there? Then create a public synonym in your original database that points to the now-remote table.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Thu Dec 19 1996 - 00:00:00 CST

Original text of this message

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