turn off archivelog for one table

[krisvdb]

Hi,

Our Oracle9i database is currently in archivelog mode.
Is it possible to turn off the archive mode for a table ??

Thanks,
Kris

[fraze]

alter table table_name nologging;

[jmodic]

The general answer for this question is:

No, you can't turn off the archive mode for a particular table. But in some cases and for very few types of DML operations you can reduce the amount of generated redos by using NOLOGGING option as sugested by fraze.

[julian]

Originally posted by fraze
alter table table_name nologging;

This will be valid for few operation on the table only: DML for example only above the HWM (append hint, etc).

[bhallar]

These setting could be overwrite by

ALTER DATABASE FORCE LOGGING;
or
ALTER TABLESPACE FORCE LOGGING

Make sure it's not there.