Re: Using DBLINK to update data in a production environment

We have been using this in a production environment for 4 months. We came up with a interesting problem. Array based update/insert/delete is not supported through a dblink. You may or may not run into this problem. In fact we only saw the problem in our QA db's. The oracle error ORA-2064 can be produced when attempting insert/update/deletes through a dblink. We were doing a "insert into x_at_remote_db as select from y where criteria is blah". This is apparently not supported.

HTH
Frank P.

"WillBrenn" <bill_brennum_at_grainger.com> wrote in message news:581021b7.0303021712.add9fd_at_posting.google.com...
> 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
Received on Mon Mar 03 2003 - 22:08:47 CST