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 list> from bbb_at_<databaseLinkToB>

-- 
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048

"sbh" <stephshomeemail_at_aol.com> wrote in message
news: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!