Hi,
Our Oracle9i database is currently in archivelog mode.
Is it possible to turn off the archive mode for a table ??
Thanks,
Kris
Printable View
Hi,
Our Oracle9i database is currently in archivelog mode.
Is it possible to turn off the archive mode for a table ??
Thanks,
Kris
alter table table_name nologging;
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.
This will be valid for few operation on the table only: DML for example only above the HWM (append hint, etc).Quote:
Originally posted by fraze
alter table table_name nologging;
These setting could be overwrite by
ALTER DATABASE FORCE LOGGING;
or
ALTER TABLESPACEFORCE LOGGING
Make sure it's not there.