Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Turning archiving off for specific Oracle table rather than entire database

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

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

    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