-
turn off archivelog for one table
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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).
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
These setting could be overwrite by
ALTER DATABASE FORCE LOGGING;
or
ALTER TABLESPACE FORCE LOGGING
Make sure it's not there.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|