4是可以回滚的。但我一开始就排除了4, 下面几种描述我没有再考虑4 delete在内。在info center里有一个章节描述了online backup和其他utilites 的兼容性:Compatibility of online backup and other utilities:TRUNCATE TABLEThe TRUNCATE statement is not compatible with...
显示全部4是可以回滚的。但我一开始就排除了4, 下面几种描述我没有再考虑4 delete在内。
在info center里有一个章节描述了online backup和其他utilites 的兼容性:
Compatibility of online backup and other utilities:
TRUNCATE TABLE
The TRUNCATE statement is not compatible with online backup because it gets a Z lock on the table and prevents an online backup from running concurrently.
DDLs that require a Z lock (such as ALTER TABLE, DROP TABLE, and DROP INDEX)
Online DMS table space backup is compatible with DDLs that require a Z lock.
Online SMS table space backup must wait for the Z lock to be released.
收起