Permissions The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin ...

You can truncate index-organized tables and temporary tables. When you truncate a temporary table, only the rows created during the current session are removed. Oracle Database changes the NEXT ...