Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Locks SQLserver

Kent D SorberNov 22 2011 — edited Dec 20 2011

Hi-

We are trying to perform NOLOCK on tables when doing selects etc .. from Oracle to SQLserver with the Oracle Gateway.
When we try selects it locks these tables on the SQLserver. I know Oracle does not use NOLOCK.
Is there anything used to not lock tables on the SQLserver from Oracle ?

Thanks-

This post has been answered by Wile E. Coyote on Nov 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2012

Added on Nov 22 2011

#heterogeneous-connectivity

19 comments

1,431 views