| Re: How to copy records between 2 instances? [message #375175] |
Thu, 02 August 2001 12:28 |
Senthil
Messages: 68
Registered: December 1999
|
Member |
|
|
You have more options...have to select which one suits for your needs...
1. Export/Import
can export a table from one instance and import into another instance...also supports incremental backup/restore.
2. Snapshot/Replication
can create snapshot of a table and will be replicated once in a while(refreshing time can be specified).
3. Using "copy" command
Create a database link between two instances and issue copy command...whenever you want to refresh the data.
4. Using "insert" command
Using database link...can also issue insert command to select data from the other instance.
HTH.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
