Truncate table table_name

Truncate table table_name

TRUNCATE Table

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10007.htm#SQLRF55330

use the command TRUNCATE Table Table_Name