Re: Help!! Moving Oracle Data??

If the data at source changes infrequently, consider using the snapshots. Although this leaves open the question of initial data transfer, but once it is done, the refresh snapshot operation will only transfer the rows that have changed. Well, provided you have created a snapshot as FAST and snapshot logs at source.

Alex

In article <72vcn2$ldu_at_sjx-ixn5.ix.netcom.com>,   "knez" <knez_at_ix.netcom.com> wrote:
> I have to pull the data from an out of state server on a daily basis. I only
> have a 56k dial up TCP/IP connection. I plan on creating the tables on a box
> at my site (Oracle8 on Novell). I want to know the best way to extract the
> raw data and import into my box... remembering I only have a 56k connection.
> The minimum data I have to pull is 2gig before any compression.
>
> If this is possible, can I automatically have this process to run over ,
> lets say, a ftp connection.
>
> Thanks for the help.
>
> Terry Dykstra wrote in message <36531fff.0_at_news.cadvision.com>...
> >You can compress export files. They often will shrink to about 20% of the
> >original.
> >
> >--
> >Terry Dykstra (TeamPS)
> >Canadian Forest Oil Ltd.
> >knez wrote in message <72uvcb$c6r_at_sjx-ixn5.ix.netcom.com>...
> >>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.
> >>
> >>
> >>
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 12:02:29 CST