Re: Help!! Moving Oracle Data??

If Oracle also runs on your in-house-box, try to use snapshots with fast refresh.
Snapshots whith fast refresh provides you an mean to transmit only changes on a table.

Example:
Master-DB

            create snapshot log on <table>;

Client-DB

            create snapshot <user>.<table> refresh fast next sysdate + 1
            as select * from <user>.<table>@<link_to_remote>;

knez schrieb:
>
> How do I get data from a remote Oracle database to my in-house box. The
> remote site has about 4 Gig of data and I access it through TCP/IP. I don't
> have a t1, just a dial-up connection. I would like to get this data daily.
> Is their a way to pack data(compression).
>
> Thanks.
Received on Thu Nov 19 1998 - 03:20:47 CST