title: Oracle 11g Deleting large amount of data without generating archive logs
body: <p>I need to delete a large amount of data from my database on a regular basis. The process generates huge volume of archive logs. We had a database crash at one point because there was no storage space available on archive destination. How can I avoid generation of logs while I delete data?</p>
  
  <p>The data to be deleted is already marked as inactive in the database.  Application code ignores inactive data. I do not need the ability to rollback the operation. </p>
  
  <p>I cannot partition the data in such a way that inactive data falls in one partition that can be dropped. I have to delete the data with delete statements.</p>
  
  <p>I can ask DBAs to set certain configuration at table level/schema level/tablespace level/server level if needed.</p>
  
  <p>I am using Oracle 11g.</p>