Skip to Main Content

SQL Developer

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
3 comments
151 views