| Re: About copy data between database [message #52412] |
Fri, 19 July 2002 07:03 |
raja mandiga
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Create DBLINK on server1.
Query on Server2 and copy the data from server1 to server2.
Write a procedure and execute in sqlplus.
Eg:
Insert into Table_name1(Select * from Table_Name1@dblink)
Insert into Table_name2(Select * from Table_Name2@dblink)
Insert into Table_name3(Select * from Table_Name3@dblink)
........
Even prompt for dblink variable in the procedure so that you can copy from multiple sources.
Also can prompt for any where condition variables.
Make life simpler :)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
