Posted by : Arjun Lagisetty Tuesday, June 13, 2017
What happens when you realize that you a need to clear years worth of data from the ODI work repository?
Whats wrong with just purging using purge option using Operator?
You are most likely to run out of undo table space with error.
ORA-30036: unable to extend segment by 8 in undo tablespace '<Undo Tablespace name>'
Delete logs in small batches one day of logs at a time. Using OdiTools and a procedure.
1. Create a procedure with the following "Command on Target" code