Re: Best way to copy tables from one Oracle server to another on scheduled basis.
Date: Sat, 11 Sep 1999 06:10:12 -0400
Message-ID: <37DA2A84.86A5824A_at_netscape.com>
[Quoted] use database link in your target machine
create table targettable as
select * from sourcetable_at_dblink;
John Chiu
johnc_at_relsol.com
Jason M wrote:
> I have tables on a remote machine that I need to copy into my local Oracle
> server. I need this to happen each evening automatically. What is the best
> way to acheive scheduled events? I am very new to Oracle.
>
> Perhaps use NT's AT. I hope not. It seems to me there must be some way to
> do this native to Oracle. I am using 7.3.3. Also, what is the best way to
> copy tables in Oracle from a remote machine to a local machine. Should I
> make use of the copy command.
>
> Thanks very much for the help,
> Jason
>
> If you respond by email, please remove the REMOVE_ from my address.
>
> REMOVE_jjm145_at_worldnet.att.net
Received on Sat Sep 11 1999 - 12:10:12 CEST