ALTER TABLE tablename ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
Causes all data currently in table to be removed. Once the data has been removed, it cannot be recovered except through use of the RESTORE facility. If the unit of work in which this alter statement was issued is rolled back, the table data will not be returned to its original state.
When this action is requested, no DELETE triggers defined on the affected table are fired. Any indexes that exist on the table are also deleted.
IMPORT FROM /dev/null OF DEL REPLACE INTO tablename
operation is fully recoverable
DELETE FROM tablename