title: delete with order by on a de-normalized table
body: <p>I need to perform delete operation(with oldest data first) on a de-normalized table which does not have any unique ID. We are considering date as parameter 
  while deciding the oldest data. But for each date their would be 600K records.And as table is very large the delete opertaion will be done in batches(Loop with rownum)
  I used below query but this one is throwing error as 'data manipulation operation not legal on this view'. But I am sure that temp is object type of table.</p>
  
  <p><code>delete from (Select A.*,rownum as rn from (select * from temp order by date) A) B where B.rn&lt;10</code></p>
  
  <p>Please let me know any alternative suggestions.</p>
  
  <p>Thanks Kifinity your solution worked but now i am confused how to make it work to delete huge number of records.. I have around 10 millions of records and need to delete them in batches. Thanks in advance.</p>