Security Software

Hi,
I want to modify dn of an entry in ods schema. Now my dn is: uid=1234567,cn=Users,dc=brand,dc=com and I want to change to 'uid=Tester001,cn=Users,dc=brand,dc=com'. Here 'Tester001' is a value of 'sn'. I have to replace the value of uid=1234567 to uid=value of 'sn'. I have around 2 billon users in our system, so I tryed to modify in ods tables instead of ldapmoddn option.

See below my sql statements for reference.

update ods.ct_uid uid
set uid.attrvalue='Tester001' where uid.entryid='909282';

update ods.ct_dn dn
set dn.rdn='uid=Tester001' where dn.entryid='909282';

update ds_attrstore set attrval='Tester001'
where entryid='909282' and attrname='uid'

update ds_attrstore set attrval='uid=Tester001,cn=users,dc=brand,dc=com'
where entryid='909282' and attrname='orclnormdn'

update ds_attrstore set attrval='uid=Tester001,cn=users,dc=brand,dc=com'
where entryid='909282' and attrname='orclentrydn'

update ods.ct_orclnormdn set attrvalue='uid=Tester001,cn=users,dc=brand,dc=com'
where entryid='909282';

commit;

After executing the above sql statements, I have restarted OID and connected to OID using Oracle Directory Manager, I'm able to see that dn is changed to 'uid=Tester001,cn=Users,dc=brand,dc=com', but if click on the entry, I'm getting the follwoing error:

"Unable to list uid=Tester001,cn=Users,dc=brand,dc=com
javax.naming.NameNotFoundException: [Ldap:error code 32 - No such Object]: remaining name 'uid=Tester001,cn=Users,dc=brand,dc=com'"

Please help me to fix this issue.