oracle中,truncate是不可以回滚的
SQL> select * from test;
ID NAME
---------- ----------
1
SQL> truncate table test;
Table truncated
SQL> rollback;
Rollback complete
SQL> select * from test;
ID NAME
---------- ----------
而在sqlserver中: