SQL & PL/SQL

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!

Best way to delete data from a huge table

Ram_AAug 29 2020 — edited Sep 3 2020

Hi Experts,

A table is having 70 millions of records and the table is being accessing by multiple applications.

I want to delete around 10 millions of records.

Could you please help me what is the best way to do this without any down time or without effecting to the application.

Note : The table is not partitioned.

Thanks in advance.

This post has been answered by Paulzip on Aug 29 2020

Jump to Answer

Added on Aug 29 2020

3 comments

8,074 views