TRUNCATE
Purpose
Use this statement to completely delete the contents of a table.
Prerequisite
You need to have the system privilege DELETE ANY TABLE, object privilege DELETE on the table or its schema, or the table belongs to the current user or one of the user roles.
Syntax
truncate::=