Delete then recreate IME and Directories with the same OID data

Document ID : KB000103792
Last Modified Date : 29/06/2018
Show Technical Document Details
Introduction:

 
Question:
unable to delete identity environment when following steps on ticket 01118119 We need to delete the IME and user directories then recreate them with the same OID We need to do this to preserve the task persistence data from the old IME
Answer:
This doc does assume that the steps are being run by the DBA
This is not a recommended procedure and should ONLY be used when the data is absolutly needed.

If the Current IME OID is 22
For Oracle:
we can run the select statement
IM_ENVIRONMENT_JDBC_SEQ.CURRVAL SELECT FROM DUAL;

To validate current value Should be 22 (this can change due to cacheing, if the number is way off, add the cache value.)
 then run
ALTER SEQUENCE IM_ENVIRONMENT_JDBC_SEQ INCREMENT by -1;

This should make the SEQ 21, so that 22 is available for creation.

The SEQUENCES for user dirs
SEQUENCE IM_DIRECTORY_SEQ
SEQUENCE IM_DIR_CONNECTION_SEQ