Stored Procedure Syntax to Copy data from Server to Server

[sbh]

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!

[mcstock]

the stored procedure doesn't manage the connection -- you create a database
link

then the SQL that manipulates the data at the remote database appends the
database link to the table name,

ie,

insert into aaa (<column list>)
select <column list> from bbb@<databaseLinkToB>

--
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
[phone]

"sbh" <st*************@aol.com> wrote in message
news:b5**************************@posting.google.c om...

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!