Re: Stored Procedure: Transfering data from one table to another from one db to another

if you have installed "distributed option" you can create a database-link an use this link.

create public database link db_link
connect to scott identified by tiger
using 'TNSNAMES-ENTRY';

insert into table_at_db_link
as select * from table;

Frank (Germany)

RKNR3755 <rknr3755_at_yahoo.com> schrieb in im Newsbeitrag: 9cfa4c94.0302020810.75ca6255_at_posting.google.com...
> Hi experts,
>
> I would like to write a stored procedure that would copy data in a
> table from
> one instance of db to another(both oracle).
>
> The problem I am trying to solve is: I have data in one table in an
> instance of database. When the web user clicks on the submit button,
> my java code should execute the stored procedure that would transfer
> the data.
>
> Can anyone help me how I should go about writing a stored procedure
> and copying the data.
> thanks in advance
Received on Sun Feb 02 2003 - 12:02:45 CST