Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update mail attribute in OIM/OID

954732Dec 17 2012 — edited Dec 17 2012
Hi Experts,
we are trying to update the Email attribute in OIM followed by OID.
we have written a scheduler to copy the username field to email field in USR Table through tcUserOperations interface, followed by change email task and update email task to OID.
But it is taking 1 hour for 1000 records to finish the job. we have 200000 Users in Production, Is there any better approach I can fasten the process?
we are having an idea to update the USR Table through SQL Querry for OIM Side.
and when we tried to update the CT_MAIL table in OID.But it is not showing the values in the front end ODSM.
Now thinking to write a scheduler seperately for OID by just connecting to ldapctx, update each records and disconnect finally after updating all the operations.
OIM Version : 9.1.0.2
OID Version: 11.1.1.3.0
Any Ideas? suggesstions? better approaches please help me.
Thanks!

Edited by: 951729 on 17/12/2012 15:07
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2013
Added on Dec 17 2012
0 comments
389 views