delete 没有这样的hint存在oracle根本不允许这样的操作存在,undo必然会产生的,没有办法避免redo以下nologging模式生效: 以下SQL语句则可以以nologging选项执行: direct load (SQL*Loader) direct load INSERT (using APPEND hint) CREATE TABLE … AS SELECT CREATE INDEX ALTER TABLE … MOVE PARTITION ALTER TABLE … SPLIT PARTITION ALTER INDEX … SPLIT PARTITION ALTER INDEX … REBUILD ALTER INDEX … REBUILD PARTITION INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line
以下SQL语句则可以以nologging选项执行:
direct load (SQL*Loader)
direct load INSERT (using APPEND hint)
CREATE TABLE … AS SELECT
CREATE INDEX
ALTER TABLE … MOVE PARTITION
ALTER TABLE … SPLIT PARTITION
ALTER INDEX … SPLIT PARTITION
ALTER INDEX … REBUILD
ALTER INDEX … REBUILD PARTITION
INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line
我曾经有个类似的测试,你可以看看
在删除数据时,如果你用truncate,是可以不写日志了。delete语句,没有见过不写日志的情况。