Sorry Deepak, I am on version 10.2. Ric- Do you think if I have to purge half million rows, parallel delete wont be that bad, and I can live without monthly partitions? Thanks On 2/21/06, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> wrote: > Sandeep, > > Which Oracle version are you on? > > Deepak -- //www.freelists.org/webpage/oracle-l