• 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