Re: Move data from one server to another

On Sun, 23 Nov 1997 15:19:32 +0100, Casper Thrane <ct_at_benau.dk> wrote:

>Hi!
>
>Is it possible to move data from one server to another server through
>sql*plus/sql-script?

If you have SQL*Net running, creating database links between the instances on each server would provide a means of accessing remote data without having to move it at all.

However it you actually do wish to migrate your data from one server to another, you could use SQL*Plus, again with SQL*Net, to copy from one instance to another. The syntax for sql*plus copy is:

copy from remote-username/remote_password @ connect_string

         to     username/password @ connect_string
         {append|create|insert|replace} tablename
         using subquery;

e.g.   copy from scot/tiger_at_T:host:remote -
         create myemp 
         using  select * from emp

Else there is good old export and import, with perhaps operating system network facilities to move your dmp files e.g. ftp

Good Luck,
Mark H Received on Sun Nov 23 1997 - 00:00:00 CST