Vignesh I
Reputation: 2221
Can Insert and delete be done at the same time in oracle
Just curious to know.If two jobs are running one is inserting into a table and other is deleting some rows from the table. Can this be performed in parallel? The table contains 300 columns with 50GB data. Will it end in a deadlock if we do so?
Upvotes: 0
Views: 2000
Answers (1)
tvCa
Reputation: 816
Given the fact you cannot remove records that have not been inserted, you can do insert and delete on the same table at the same time, but not on the same records. Hence, you cannot deadlock. You can lock though. You'll need to come up with something more complex, to deadlock Oracle.
Upvotes: 1
Related Questions
- SQL Update,Delete And Insert In Same Time
- Can we update a record in a table and simultaneously insert the updated record in another table in Oracle DB 11g
- Delete and Insert simultaneously on a oracle table
- Multiple inserts in Oracle SQL like MySQL?
- Oracle - Deleting or inserting rows via cursor
- select->insert->delete into one sql statement: possible?
- Insert then delete rows out of an oracle table
- Insert and update simultaneously
- Is it possible to do Insert and Delete in a same query in Oracle10g?
- In Oracle, can I do an "insert or update values into TABLE"