truncate table with large number of data

Posted by Roshan on Sep 05, 2017; 2:17pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/truncate-table-with-large-number-of-data-tp3402.html

Oracle Database 11.2.0.3.0

SunOS

 

Hi,

 

I have a table with 17 million records. I want to delete records (around 900,000) from the table where date is March 2014

 

The issue is it takes lots of time to scan the table and delete. 1 record takes around 5 minutes to complete.

 

how can I increase the rate to delete records?

 

Regards,

 
Roshann