Re: Stored procedure access remote database

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

.

Relevant Pages

  • Re: Why is "shutdown abort", then backup bad
    ... Sybrand Bakker, Senior Oracle DBA wrote, amongst other things: ... How many flame wars? ... What, Mr. Bullshit, would ...
    (comp.databases.oracle.server)
  • Re: exp and archive available.... recover table
    ... recoverd with all data by using log minor. ... Sybrand Bakker ... Senior Oracle DBA ... David Fitzjarrell ...
    (comp.databases.oracle.server)
  • Re: Oracle Grid Control vs 8i/9i
    ... >>> It is an established and documented fact that Oracle 10g can't ... >>> Sybrand Bakker, Senior Oracle DBA ... Migration of those databases is planned for next year. ...
    (comp.databases.oracle.server)
  • Re: Not able to connect from another unix account
    ... Look at the metalink note 335063.1 and ... patch. ... > Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: Forms 9.0.4.2
    ... You only need to hit ctrl-end to stop top-posting. ... Sybrand Bakker, Senior Oracle DBA ... Sounds like too much hard work (mind you, like you say, I am lazy). ...
    (comp.databases.oracle.misc)