Re: Using DBLINK to update data in a production environment

WillBrenn wrote:

> I am involved in a project where we are considering linking SAP to an
> external
> Oracle database. The method we would like to use for the link is
> Oracle's DBLINK functionality. I would like to know if anyone is
> currently using DBLINK to maintain data on a remote database in a
> production environment. The info that I would like to obtain is:
>
> 1. The versions of Oracle used.
> 2. Is there Insert, Update and Delete activity against the remote DB.
> 2. How long in production.
> 3. Issues if any.
> 4. Is there any connection to an SAP system?
>
> Thanks in advance to any feedback provided.
>
> Thanks

1. All versions will work 2a. Yes 2b. Years
2. Performance
3. No but that shouldn't make any difference. Oracle is Oracle is Oracle.

Depending on transaction size and volume this may or may not be a problem. I would suggest you put this in a test environment and simulate real-world conditions as you expect them to exist.

Daniel Morgan Received on Sun Mar 02 2003 - 21:42:28 CST