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
Debasis Sahoo replied
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