始终记录的活动

有些数据库操作始终生成逻辑日志记录（即使您关闭事务日志记录或使用非日志记录表）。

以下操作始终为永久表而记录：
  • 某些 SQL 语句，其中包括 SQL 数据定义语句。
  • 存储空间备份
  • 检查点
  • 对数据库服务器配置的管理更改（如添加块或数据库空间）
  • 为表分配新扩展数据块
  • 对数据库的日志记录状态的更改
  • 智能大对象操作：
    • 创建
    • 删除
    • 分配与取消分配扩展数据块
    • 截断
    • 组合与分割块可用列表页
    • 更改 LO 头和 LO 引用计数
  • 智能大对象空间元数据
  • BLOB 空间
下表列出了生成操作的语句，即使关闭了事务日志记录也会记录这些操作。
  • ALTER ACCESS_METHOD
  • ALTER FRAGMENT
  • ALTER FUNCTION
  • ALTER INDEX
  • ALTER PROCEDURE
  • ALTER ROUTINE
  • ALTER SECURITY LABEL COMPONENT
  • ALTER SEQUENCE
  • ALTER TABLE
  • ALTER TRUSTED CONTEXT
  • ALTER USER
  • CLOSE DATABASE
  • CREATE ACCESS_METHOD
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE DATABASE
  • CREATE DISTINCT TYPE
  • CREATE EXTERNAL TABLE
  • CREATE FUNCTION
  • CREATE FUNCTION FROM
  • CREATE INDEX
  • CREATE OPAQUE TYPE
  • CREATE OPCLASS
  • CREATE PROCEDURE
  • CREATE PROCEDURE FROM
  • CREATE ROLE
  • CREATE ROUTINE FROM
  • CREATE ROW TYPE
  • CREATE SCHEMA
  • CREATE SECURITY LABEL
  • CREATE SECURITY LABEL COMPONENT
  • CREATE SECURITY POLICY
  • CREATE SEQUENCE
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE TEMP TABLE
  • CREATE TRIGGER
  • CREATE TRUSTED CONTEXT
  • CREATE USER
  • CREATE VIEW
  • CREATE XADATASOURCE
  • CREATE XADATASOURCE TYPE
  • DROP ACCESS_METHOD
  • DROP AGGREGATE
  • DROP CAST
  • DROP DATABASE
  • DROP FUNCTION
  • DROP INDEX
  • DROP OPCLASS
  • DROP PROCEDURE
  • DROP ROLE
  • DROP ROUTINE
  • DROP ROW TYPE
  • DROP SECURITY
  • DROP SEQUENCE
  • DROP SYNONYM
  • DROP TABLE
  • DROP TRIGGER
  • DROP TRUSTED CONTEXT
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • DROP XADATASOURCE
  • DROP XADATASOURCE TYPE
  • GRANT
  • GRANT FRAGMENT
  • RENAME COLUMN
  • RENAME DATABASE
  • RENAME INDEX
  • RENAME SECURITY
  • RENAME SEQUENCE
  • RENAME TABLE
  • RENAME TRUSTED CONTEXT
  • RENAME USER
  • REVOKE
  • REVOKE FRAGMENT
  • TRUNCATE
  • UPDATE STATISTICS
  • SAVE EXTERNAL DIRECTIVES
  • SET CONSTRAINTS
  • SET Database Object Mode
  • SET INDEXES
  • SET TRIGGERS
  • START VIOLATIONS TABLE
  • STOP VIOLATIONS
  • ALTER ACCESS_METHOD
  • ALTER FRAGMENT
  • ALTER FUNCTION
  • ALTER INDEX
  • ALTER PROCEDURE
  • ALTER ROUTINE
  • ALTER SECURITY LABEL COMPONENT
  • ALTER SEQUENCE
  • ALTER TABLE
  • ALTER TRUSTED CONTEXT
  • ALTER USER
  • CLOSE DATABASE
  • CREATE ACCESS_METHOD
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE DATABASE
  • CREATE DISTINCT TYPE
  • CREATE EXTERNAL TABLE
  • CREATE FUNCTION
  • CREATE FUNCTION FROM
  • CREATE INDEX
  • CREATE OPAQUE TYPE
  • CREATE OPCLASS
  • CREATE PROCEDURE
  • CREATE PROCEDURE FROM
  • CREATE ROLE
  • CREATE ROUTINE FROM
  • CREATE ROW TYPE
  • CREATE SCHEMA
  • CREATE SECURITY LABEL
  • CREATE SECURITY LABEL COMPONENT
  • CREATE SECURITY POLICY
  • CREATE SEQUENCE
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE TEMP TABLE
  • CREATE TRIGGER
  • CREATE TRUSTED CONTEXT
  • CREATE USER
  • CREATE VIEW
  • CREATE XADATASOURCE
  • CREATE XADATASOURCE TYPE
  • DROP ACCESS_METHOD
  • DROP AGGREGATE
  • DROP CAST
  • DROP DATABASE
  • DROP FUNCTION
  • DROP INDEX
  • DROP OPCLASS
  • DROP PROCEDURE
  • DROP ROLE
  • DROP ROUTINE
  • DROP ROW TYPE
  • DROP SECURITY
  • DROP SEQUENCE
  • DROP SYNONYM
  • DROP TABLE
  • DROP TRIGGER
  • DROP TRUSTED CONTEXT
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • DROP XADATASOURCE
  • DROP XADATASOURCE TYPE
  • GRANT
  • GRANT FRAGMENT
  • RENAME COLUMN
  • RENAME DATABASE
  • RENAME INDEX
  • RENAME SECURITY
  • RENAME SEQUENCE
  • RENAME TABLE
  • RENAME TRUSTED CONTEXT
  • RENAME USER
  • REVOKE
  • REVOKE FRAGMENT
  • TRUNCATE
  • UPDATE STATISTICS
  • SAVE EXTERNAL DIRECTIVES
  • SET CONSTRAINTS
  • SET Database Object Mode
  • SET INDEXES
  • SET TRIGGERS
  • START VIOLATIONS TABLE
  • STOP VIOLATIONS TABLE
父主题： SQL 语句和数据库服务器活动的日志记录