There are many development environment where the $ tables created in the ODI work schema are not removed at proper interval .As the development grows the more number of $ tables grow especially in the environment where dynamic $ tables created for every interface run .
This particular procedure drops all the $ tables. Please use this first in your development and modify the codes according for your environment.
In the above step , we are dropping all the $ tables from Work Schema . My Work Schema is ODI_TEMP , Selected any required Schema which have the necessary permission to do the drop. Provide the Work_Schema in TEMP_SCHEMA option.
October 28, 2015 at 7:33 AM
Hi expert,
Very thankful for the post.
I have followed the procedure you have shared,
I am getting invalid SQL statement.
I have created an option named tempSchema and its value as ODI (which is my work schema)
I am getting error.
please help.
Thanks,
Santhosh
April 18, 2011 at 5:10 AM
Really Useful
Kshitij