Re: Move data from one server to another

sure; create a database link from the target database to the source database like

create database link my_link connect to user identified by password using 'connect_string';

and then you can insert into target tables with

insert into target_tables (blah,blah1,blah2) values select (blah,blah1,blah2) from source tables;

or create table xyz as select * from abc_at_database_link; ...

Casper Thrane wrote:

> Hi!
>
> Is it possible to move data from one server to another server through
> sql*plus/sql-script?
> --
> Casper Thrane
> Systemdeveloper
> Benau A/S
Received on Sun Nov 23 1997 - 00:00:00 CST