Re: Stopping archiving of a single table

In article <59ca7j$15r_at_mel.hargray.com>, Peter Marusek <pmaruse_at_hargray.com> writes
>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
>

This is a bit of a shot in the dark based on reading some release notes. No guarantees that it is even feasible.

Oracle 7.3 supports creating a tablespace as TEMPORARY. I think this means no logging. It is primarily for Oracle's own temporary segments, but you may be able to create your own table in it.

-- 
Jim Smith