Re: Stopping archiving of a single table

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.