shirish muley

• Mar 16th, 2006

 

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

Sajid Ansari

• Jun 24th, 2006

 

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.

gouthami

• Aug 15th, 2006

 

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;

sangeetha

• Dec 27th, 2006

 

In oracle,DDL command,if u give TRUNCATE command,storage of data will get lost and structure of table will be there as it,roll back option is not there once u truncate the table