Hi All,
I am trying to run the procedure parallel using DBMS_JOBS, 5 jobs are submitting in parallel and records are divided based on the main query. but the problem is. after execution, all are getting locked.
in my analyze, from source query returns duplicated records in 5 jobs, [assume same records comes in 5 parallel jobs] and my target table having unique and normal indexed columns.
The lock is happen for indexed column, and locked object showing same rowid. is this possible for duplicate rowid for duplicate rows, dont know really convey the info properly.
Same record in different jobs, generating same rowid and it get locked in index. this is my understanding. is this true?
Donno exactly what is happening. when i drop the index, it is getting locked in another index. Do i need to remove all index and constraints while performing parallel jobs? or I need to restrict the duplicate record.