I hope I am posting this in the correct forum. I am a BW developer and interested to know if there is a way to delete/clean redo logs on a particular table. For example: I have an ODS and I would like to delete its redo logs each time after it is loaded from the source system. Is it possible to do so? I believe on oracle it is doable but I would just like to do this on a table level if possible
On an individual table level, it can't be done.
but it can be deleted from Oracle level, which is generally done when we do a system copy let's say from production to quality for refreshing the data from production to quality and then delete the restored redo log of production in quality box.
for a basic understanding ..
Edited by: Debasis Sahoo on Oct 6, 2008 11:46 PM