Skip to Main Content
Forums

SQL Developer

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!

Delete a large amount of data on Partition

User_SWR12Mar 11 2022

Hi
I'm trying to delete a high number of records from a partition table for that I'm using the following command.
DELETE FROM tab PARTITION (P_082020);
The problem is that it takes too long.
Can you help me to find the best way to delete records from a table with millions of records without having to recreate it?

Comments

Post Details

Added on Mar 11 2022
#delete, #performance, #sql, #sql-developer
3 comments
2,034 views