Re: Stopping archiving of a single table

We also had a similar problem and there is no way other than the create table unrecoverable option. The way we did was to use PL/SQL tables insead of real tables. If you are using Oracle 7.3 then it is not so complex, but we had 7.2 so it was a bit complex. Once we had selected the data into the PL/SQL table (arrays) we were not updating(or inserting) anything.

I am not sure if you utilise this, but if you can't then Good Luck to you if some one can come up with a better idea.

Thanks

Lakshmikant Sharma

Peter Marusek <pmaruse_at_hargray.com> wrote in article <59ca7j$15r_at_mel.hargray.com>...
> 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 Fri Dec 20 1996 - 00:00:00 CST