posted 5 years ago
I'm pretty sure once you issue a truncate, your data is gone. It doesn't wait for a commit. From this web page,
Therefore commit is useless here.DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.