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]

Re: Stored Procedure Syntax to Copy data from Server to Server

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 listfrom bbb@<databaseLi nkToB>

--
Mark C. Stock
email mcstock -enquery(dot)com

https://www.enquery.com

(888) 512-2048

"sbh" <stephshomeemai l@aol.comwrote in message
news:b5ea6277.0 311041035.50e32 352@posting.goo gle.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!