title: Issues with truncating an Oracle table on a daily basis
body: <p>Assume there is a staging table, which has some indexes, constraints defined on it. A process is dumping data into this table on a daily basis. A few million rows per day. Another process is taking data from the table on daily basis as well.
  Once read, that days data is not worth any more, so no point in keeping the data in the table.</p>
  
  <p>Current solution is to truncate the table (as opposed to "delete from"  the table because it is going to take long time considering the indexes and constraints over it) and load the data on daily basis. </p>
  
  <p>My question is, is there any technical issues in doing truncating a table on daily basis?</p>
  
  <p>PS: Using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit</p>