how to delete all the data from the table in sqlplus oracle

Question

i want to delete all the data rows in the table. but without dropping the table. delete statement has a where clause so i have to give one by one for each row. is there any other way of deleting the whole data rows in the table.

this is Oracle and using sqlplus

Answer 1

You can try: TRUNCATE TABLE tableName

Answer 2

Truncate Table tablename

http://www.orafaq.com/faq/difference_between_truncate_delete_and_drop_commands

You can delete all records with delete from tablename also but truncate is much faster

Answer 3

It will be better that you drop constraint and then use Truncate command and after getting rid of data , apply the constraint again.