Oracle Lock [message #650645] |
Thu, 28 April 2016 11:26 |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
Hi,
I have a one job which where insert and update in the table "A" through loop and after every dml commit executes and the same time other jobs run which is required the same data from table "A" When we select data from table A and insert the record in table B
it hangs and after 60 minute the insertion complete.
How to get the data from table A and insert into B in the running process. Please suggest.
Thanks
Prashant
|
|
|
|
|
Re: Oracle Lock [message #650649 is a reply to message #650646] |
Thu, 28 April 2016 11:52 |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
Yes It does not block,but in our case it hangs. Table A has a clob column where we insert record and in the same time we run this dml
"insert into table B SELECT * FROM A" and it hangs.
|
|
|
|
|
Re: Oracle Lock [message #650652 is a reply to message #650651] |
Thu, 28 April 2016 12:28 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
If table A and table B have to have the same data, is there a reason you can't make B a synonym for A and then you actually only have one table that both applications will use. We need more information.
|
|
|