Re: Best way to copy tables from one Oracle server to another on scheduled basis.

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 - 05:10:12 CDT