Turning archiving off for specific Oracle table rather than entire database

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
Is it possible to turn archiving off for a specific Oracle table rather than for the entire database?

Resolution:
Logging can be turned off for a specific table or index with these commands:

alter table znnn nologging;
alter index znnn_id nologging;

Or nologging can be specified as a parameter in the CREATE for the table or index.

Note: You must *not* specify "nologging" for base/corpus tables. (See KB 4138 in regard to which tables these are.)

Article last edited: 10/8/2013