Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedure access remote database

Re: Stored procedure access remote database

From: Cliff Martin <cliff.martin_at_gmail.com>
Date: 26 Mar 2007 08:40:54 -0700
Message-ID: <1174923654.817969.112760@e65g2000hsc.googlegroups.com> 





> Wouldn't you better just issue

> insert into <local_table>

> select *

> from <table>@remote_db

> directly?

> What you describe is very inefficient.

> Look into the Distributed database manuals for further info.

>

> --

> Sybrand Bakker

> Senior Oracle DBA




I have to supply different credentials for the remote DB. I would very
much like to do what you suggest, I just don't see how to do it right
now.



Cliff
Received on Mon Mar 26 2007 - 10:40:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US