Oracle Clearing table SQL statement and difference between Truncate and delete

The difference between delete and truncate: delete generates rollback. If you delete a table with a large amount of data, it will take up a lot of rollback segments. truncate is a DDL operation and does not generate rollback, which is faster.

Oracle Clearing table SQL statement and difference between truncate and delete

Truncate table [table name]

Use the truncate statement to delete all rows from the table or the cluster. By default, the oracle database tutorial also performs the following tasks:

The only exception to unallocation is that all buckets used in the deleted row are specified by minextents.

The truncate part of the process set for the next storage parameter cancels the final range size.

Deleting and truncate statement rows can be more effective than dropping and recreating a table. Dropping and re-creating an invalid dependent object for a table requires you to add the Object Privilege on the table and require you to re-create the index, integrity constraints, and store parameters in the triggers and respecify tables. Truncate has no such impact.

Deleting and truncate statement rows can be faster than deleting all rows using the delete statement, especially if there are many triggers in the table, indexing and other dependencies.

Differences between delete and truncate

Delete generates rollback. If you delete a table with a large amount of data, it takes up a lot of rollback segments. truncate is a ddl operation and does not generate rollback, which is faster.
*/