When I use Toad for Oracle and I choose to TRUNCATE a table using the GUI, there is a prompt to “Drop” or “Reuse” and this is not the case in Toad Data Point. This means that the data should be preserved in the UNDO table space.
This is not the case for Toad Data Point. I suggest that there be a prompt added to the TRUNCATE call from the GUI that asks “Send as DELETE?” or something similar, so as to preserve the flashback capabilities, by maintaining the removal of data in the UNDO space for Oracle environments. Further, there may be other database systems that have a similar treatment of DELETE versus TRUNCATE.
Please consider this addition.