Oracle empty table SQL statements and truncate and delete differences

Oracle empty table SQL statements and truncate and delete differences

TRUNCATE TABLE [name]

Remove or cluster all rows from the table using the TRUNCATE statement. By default, the Oracle Database tutorial also performs the following tasks:

The only exception to deallocate is that all of the storage space used in the deleted row is specified by the minextents parameter

The next storage parameter setting cancels the last range size from the truncate portion of the process

Deleting rows with truncate statements can be more effective than dropping and recreating the table. Dropping and recreating a table's table invalid dependent object, requires you to complement the object's privileges on the table, and asks you to re-create the index, the integrity constraints, and the triggers on the table and respecify its stored parameters. Truncate had these effects without.

Deleting and Truncate statement rows can delete all rows than with the DELETE statement, especially if there are many triggers in the table, indexing and other dependencies are faster.

The difference between delete and truncate

Delete produces rollback, and if you delete a table with large amounts of data, it can be slow and take up a lot of rollback segments. Truncate is a DDL operation that does not produce rollback and is faster.
*/