Activity That Is Always Logged

Some database operations always generate logical-log records, even if you use nonlogging tables on Extended Parallel Server.

The following operations are always logged for permanent tables:

• SQL data definition statements:

  ALTER INDEX	CREATE VIEW
  ALTER TABLE	DROP INDEX
  CREATE DATABASE	DROP PROCEDURE
  CREATE INDEX	DROP SYNONYM
  CREATE PROCEDURE	DROP TABLE
  CREATE SCHEMA	DROP TRIGGER
  CREATE SYNONYM	DROP VIEW
  CREATE TABLE	RENAME COLUMN
  CREATE TRIGGER	RENAME TABLE

• Storage-space backups
• Checkpoints
• Administrative changes to the database server configuration such as adding a chunk or dbspace
• Allocation of new extents to tables
• A change to the logging status of a database