CODEWITHSUNDEEP
oracle11g
Rupesh Hotkar
Rupesh Hotkar

Reputation: 3

Delete and Insert simultaneously on a oracle table

I have a table X and table Y . There is a java subscriber that inserts data continously on X . On X we have a insert trigger that , dumps data into Y on each insert. I want to delete the processed records from Y , while simultaneous inserts are happening on Y. Will the delete on Y encounter a lock

Upvotes: 0

Views: 186

Answers (1)

Visionary Zen
Visionary Zen

Reputation: 80

It shouldn't. Unless otherwise specified in your DML, locks occur on a row level. See this answer here.

Upvotes: 1

Related Questions