ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Dropping $ Tables

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.

image

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.

image

Download the procedure

http://cid-d7195c8badc40d0b.skydrive.live.com/embedicon.aspx/odiexperts.com/TRT_ODI_DROP_TEMP_TABLES.xml

2 Comments

  1. 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

Leave a Reply

Required fields are marked *.