Re: Problem with DBlinks

Hi Clare,

I would test the db_link first. If you can describe and select data through the database link
then, I would look at the permissions of the user that connects with the db_link. Does that
user have permission to insert the data to the table? If so, then what data is actually being inserted.
Does the data violate any constraints? If all of these things look good, and as you've said
there are no locks on the table then start looking at the network.

Nevin Hahn
nhahn_at_evoke.com

H. Clare <hclare_at_pharma.fraser-williams.com> wrote in message news:8pleri$jlu$1_at_gxsn.com...
> Hi,
>
> we've got a problem with inserting over a database link,
> The two databases are both 8.1.5, the insert is a single line insert
> (although it is part of a much larger process).
>
> The whole process seems to stop when it gets to an insert over the
 database
> link, only recoverable by shutting down the database with abort.
>
> Any suggestions as to why this might be? I've checked all of the v$ views
> for locks (the ones I know of anyway) and there doesn't seem to be a
 problem
> in that area.
>
> Cheers...
>
>
>
Received on Tue Sep 12 2000 - 13:24:18 CDT