OIM – Removing UDFs

Statement :

Removing the UDFs manually using the alter table command is not recommended and will not help you actually.

I believe I have seen code on internet which will take input of the UDFs you want to delete and will do all the work for you of deleting the UDFs and its references.

But since you have already rolled back the sandbox, use the code to delete the UDFs and it probably should remove all the references; if not, you might have to modify the code.

After you delete the UDFs through code, you will have to take the export of USER.xml and remove all the references of the UDFs and import it back.

This should solve your issue.

If this does not resolve your issue, please check you have entries of the UDFs in the following tables:

a. SDC

b. MV_USER_COLS

c.  USR (per your statement, you should not have any columns in this table)

Ref : Oracle Docs/Forums.

Advertisements

Post Process Event Handlers

http://tejshare4oim.blogspot.in/2013/02/post-process-event-handler.html

Reference documents from oracle:

Extending User Managemen bu Developing Event Handlers:
http://docs.oracle.com/cd/E14571_01/doc.1111/e14309/oper.htm#CCHHHGEC

Using API:
http://docs.oracle.com/cd/E14571_01/doc.1111/e14309/apis.htm

Forums Discussions:
https://forums.oracle.com/forums/message.jspa?messageID=10174401#10174401
https://forums.oracle.com/forums/thread.jspa?messageID=9792462
https://forums.oracle.com/forums/message.jspa?messageID=10176817