以下 SQL 语句无论数据库日志记录方式如何,均不生成日志记录。
- ALLOCATE COLLECTION
- ALLOCATE DESCRIPTOR
- ALLOCATE ROW
- CLOSE
- CONNECT
- DATABASE
- DEALLOCATE COLLECTION
- DEALLOCATE DESCRIPTOR
- DEALLOCATE ROW
- DECLARE
- DESCRIBE
- DISCONNECT
- FETCH
- FREE
- GET DESCRIPTOR
- GET DIAGNOSTICS
- INFO
- LOCK TABLE
- OPEN
- OUTPUT
- PREPARE
- RELEASE SAVEPOINT
- SAVEPOINT
- SELECT
- SET AUTOFREE
- SET COLLATION
- SET CONNECTION
- SET DATASKIP
- SET DEBUG FILE
- SET DEFERRED_PREPARE
- SET DESCRIPTOR
- SET ENCRYPTION PASSWORD
- SET ISOLATION
- SET LOCK MODE
- SET LOG
- SET OPTIMIZATION
- SET PDQPRIORITY
- SET ROLE
- SET SESSION AUTHORIZATION
- SET STATEMENT CACHE
- SET TRANSACTION
- SET Transaction Mode
- SET USER PASSWORD
- UNLOCK TABLE
- WHENEVER
- SET ENVIRONMENT
- SET EXPLAIN
对于临时数据库空间中的临时表,不记录任何内容,甚至 始终记录的活动中所列的 SQL 语句也不记录。如果您在 DBSPACETEMP 中包含了临时(非日志记录)数据库空间,那么数据库服务器会将非日志记录表先放在这些临时数据库空间中。有关更多信息,请参阅临时表。