Page 1 of 1

Inserting / Updating Oracle table...

Posted: Thu Sep 02, 2010 1:05 pm
by allavivek
Hi All,

A doubt came accross my mind ..

Can we update/insert same table at a time in a job using different links..

Like below..database is oracle..


...............transfromer--------------TABLE(insert)
|
TABLE(insert)

and what about locking mechanism of table when used??

Thank you...

Posted: Sun Sep 05, 2010 8:16 pm
by keshav0307
yes if you can make sure that you are not updating the same record, you are inserting from other link.