469,356 Members | 2,681 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

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!
Jul 19 '05 #1
1 8419
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
(888) 512-2048

"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!

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Toonman | last post: by
5 posts views Thread by Dennis | last post: by
reply views Thread by SOI_0152 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.