Oracle Data Integrator is one of the most widely used ETL tools on the market, but from time to time, it may cause headaches when developers try to work together on the same project and try to modify shared objects. One of the problems is that objects that are forgotten get locked. Unless you have Supervisor grants, you will not be able to unlock the object. In this article, I will try to explain how to handle this problem without granting Supervisor to everyone.
Disclaimer: Use at your own risk. The method described in this post manipulates some records in Oracle Data Integrator's repository. Directly manipulating Oracle Data Integrator's repository tables may lead to unexpected behavior or crash of the software. The writer of the post can not be held liable because of the unexpected behaviors or crashes.
No comments:
Post a Comment