title: Renaming an organization in Oracle Identity Manager link: https://onemoretech.wordpress.com/2008/10/28/renaming-an-organization-in-oracle-identity-manager/ author: lembobro description: post_id: 436 created: 2008/10/28 19:03:24 created_gmt: 2008/10/28 19:03:24 comment_status: open post_name: renaming-an-organization-in-oracle-identity-manager status: publish post_type: post

Renaming an organization in Oracle Identity Manager

“They” said it couldn’t be done. Well, not officially, of course. It’s not official until you file an SR and get back the message “Sorry, this is a bug, here is your bug number…”.

As everyone knows, although the documentation for Oracle Identity Manager (OIM) is quite voluminous, it is not always enlightening. While that might be acceptable when it comes to something like, say, religion or politics, it really does complicate matters when you’re talking about massive enterprise user provisioning operations such as those OIM is advertised as being the “must-have” solution for.

So, what to do if you create an “organization”, then later delete it, only to find you need to create a new organization with the old name? The system won’t let you create a new one with the same name, because the “deleted” org is really not deleted, just irretrievably “disabled”.

Obviously, the answer is “rename the old one”. Obvious to those who don’t mind the clutter of a thousand previously used org names plastered all over their user interface, that is.

Without any other solution in the offing, we decided to follow Oracle support’s recommended solution and rename the old org.

(by we, I mean myself, the Great Eldapo, and my blogless colleague, Rob K., a/k/a eldapino)

The following SQL would be executed as the OIM database owner using sqlplus (commands to system entered in bold, of course this being SQL, all commands are case-insensitive):

`

SQL> **UPDATE act SET act_name =**
2 **‘Deleted NeverMeantToCreateThis’ WHERE act_key =**
3 **(SELECT act_key FROM act_name = ‘NeverMeantToCreateThis’);**
1 row updated.
SQL> **commit**;
Commit complete.

`

For some of the backstory on how we came by this bit of knowledge, see Rob’s first post on his new blog.

Copyright 2004-2019 Phil Lembo