Stored Procedure Syntax to Copy data from Server to Server

From: sbh <stephshomeemail_at_aol.com>
Date: 4 Nov 2003 10:35:12 -0800
Message-ID: <b5ea6277.0311041035.50e32352_at_posting.google.com>

I need to copy data from a table on one Oracle server to another.

Scenario: Need to create a stored procedure in server a, database aa that will copy data from server b, database bb, table bbb to server a, database aa, table aaa. Let's say I have a user on server b, database bb named userB (password pw) that has rights to table bbb.

Can anyone help me with the syntax - just for the connection part?

Is this possible with a stored procedure?

Thank you for any help! Received on Tue Nov 04 2003 - 19:35:12 CET

This message: [ Message body ]
Next message: David Rose: "Oracle and Windows Server 2003"
Previous message: Robert: "New Oracle monitoring tool ... Sorry :-) here is the webpage"
Next in thread: mcstock: "Re: Stored Procedure Syntax to Copy data from Server to Server"
Reply: mcstock: "Re: Stored Procedure Syntax to Copy data from Server to Server"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message