Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!feedme.news.mediaways.net!newsfeeder.ewetel.de!newsreader.ewetel.de!not-for-mail From: "Frank" Newsgroups: comp.databases.oracle.misc Subject: Re: Stored Procedure: Transfering data from one table to another from one db to another Date: Sun, 2 Feb 2003 19:02:45 +0100 Organization: EWE TEL GmbH Lines: 30 Message-ID: References: <9cfa4c94.0302020810.75ca6255@posting.google.com> NNTP-Posting-Host: dynadsl-080-228-69-231.ewetel.net X-Trace: news1.ewetel.de 1044208770 9563 80.228.69.231 (2 Feb 2003 17:59:30 GMT) X-Complaints-To: abuse@ewetel.net NNTP-Posting-Date: Sun, 2 Feb 2003 17:59:30 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Xref: newsfeed1.easynews.com comp.databases.oracle.misc:92605 X-Received-Date: Sun, 02 Feb 2003 10:58:52 MST (news.easynews.com) 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@db_link as select * from table; Frank (Germany) RKNR3755 schrieb in im Newsbeitrag: 9cfa4c94.0302020810.75ca6255@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