How you are importing the work repository through command prompt or using ODI.
I am importing from Designer from File --> Import-->workrep. and with INSERT_UPDATE mode.
Is it giving any error during import. can you share the image.
No, it is not giving any error. It is just showing processing. When we checked with the DBA, they told us that our session was in inactive mode and waiting for user inputs. And the above are the list of tables which were having locks on them.
Thanks & Regards
Closing this chain.
With Oracle support, we have executed below steps instead of exporting and importing complete odi environment.
1. database copy from dev to stage
2. exeuted some scripts to change the internal rep ids.
this was worked for us.