Transfer Data [message #41242] |
Wed, 11 December 2002 16:31 |
Raju
Messages: 74 Registered: March 1999
|
Member |
|
|
We have two databases. Development and Production, both running on Oracle 8i. both are in same physical location. i'm able to connect both servers from oracle client. most of the tables are similar in both DBs. how can i transfer data from
table A (Prod server) to table A (dev server)
I'm new to this oracle environment, can any tell me the exact step by step statement for this transfer.
thank you
|
|
|
|
Re: Transfer Data [message #41268 is a reply to message #41242] |
Thu, 12 December 2002 10:13 |
vinay
Messages: 27 Registered: December 1999
|
Junior Member |
|
|
use the following command to create the dblink,
create database link LINK_NAME connect to USER_NAME identified by PASSWORD using 'DATABASE';
link_name -- is the name of the dblink U wish to give
user_name -- is the name of the user in the other database
password -- is the password of the above user
database -- is the name of the other database
here is the syntax to access the table in that database using the newly created dblink,
USER_NAME.TABLE_NAME@LINK_NAME
Vinay
|
|
|