TRUNCATE cannot be rollbacked i.e. restore cannot work on TRUNCATE.

So while truncating a table if u feel you might need the data later use DELETE

instead of TRUNCATE which can be rollbacked.

E.g. DELETE from tablename

Truncate command is a DDL command

In oracle there is Autocommit after DDL command so no rollback can be done But if u want to restore your data You can use your previous dump to restore your data back by using Oracle import utility.

Truncate is a DDL Command. When used in SQL Statement Deletes the data of the table permanently i.e It Cannot be rolledback Leaving only the structure behind.

Ex.truncate table tablename;

if the needs to be restored than use the delete command .

Ex.Delete *or columns from tablename;