Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate or Delete All records - Table space optimising

user7592430Sep 10 2021

Hi I'm Periodically Updating a Table by Deleting all records and inserting all new records.
Is it better to Truncate the table instate of Delete All records ?
Is it reclaiming the table space - allocated disc space and memory for the deleted records,
or the tablespace increases each time I delete and insert.

Comments
Post Details
Added on Sep 10 2021
4 comments
481 views