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
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
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.)
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