Issue - ORA-00001: unique constraint (IDM_OIM.PK_USR) violated at line number 1308
Problem Summary - Bulk Load Failed due to users already present with the usr_key, so find out the failed users from table
select * from USR_11G_FROM_PROD_EX1;
Update the usr_key and bulk load the failed users.
Solution - Onboard the failed users with different usr_key
Issue - BULK LOAD UTILITY FAILS WITH "ORA-00907: MISSING RIGHT PARENTHESIS"
Problem Summary - Bulk Load fails when used CSV File as a input in Kubernetes environment.
Solution - Oracle is having a patch on this issue
Patch 33997963: BULK LOAD UTILITY FAILS WITH "ORA-00907: MISSING RIGHT PARENTHESIS"
Problem Summary - Bulk Load Failed due to users already present with the usr_key, so find out the failed users from table
select * from USR_11G_FROM_PROD_EX1;
Update the usr_key and bulk load the failed users.
Solution - Onboard the failed users with different usr_key
Issue - BULK LOAD UTILITY FAILS WITH "ORA-00907: MISSING RIGHT PARENTHESIS"
Problem Summary - Bulk Load fails when used CSV File as a input in Kubernetes environment.
Solution - Oracle is having a patch on this issue
Patch 33997963: BULK LOAD UTILITY FAILS WITH "ORA-00907: MISSING RIGHT PARENTHESIS"
Note: Before applying any patch to your environment, please confirm it on Oracle Support.
No comments:
Post a Comment