best way to delete large number of rows

[pando]

Originally posted by Orca777
Use materialized View with View-logs instead (of the table) then you can do it! without downtime.
Orca

it can be done but there is still downtime though