Re: Fast transfer from Xbase to Oracle
From: Damond Walker <dwalker_at_newarklx.black-oak.com>
Date: Wed, 3 Jun 1998 15:36:59 -0400
Message-ID: <Pine.LNX.3.96.980603153528.11837A-100000_at_newarklx.black-oak.com>
Date: Wed, 3 Jun 1998 15:36:59 -0400
Message-ID: <Pine.LNX.3.96.980603153528.11837A-100000_at_newarklx.black-oak.com>
On 3 Jun 1998, Zeljko Posilovic wrote:
> I'm rather new in Oracle, so excuse me if the question is obsolete...
>
> I have to translate rather big Xbase (Clipper) Dbf's with no memo fields
> into Oracle. To be correct, it is 134 Dbf's with 10.000 to 4.000.000
> records. Total size of those files is 3.5 GB. Any advise about the fastest
> (not to mention easiest) way to do the job?
>
The easiest (though probably not the fastest) way to transfer files from DB to DB (at least under Win95) is to use Access as the piping tool. It's easy to start but not likely the fastest way of doing things. You might want to run a small test case for each table 1st but other that, I've never had a problem doing it.
///////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\ // Damond Walker \\// [moribund_at_netgsi.com] \\ // Will Program For Beer //\\ No job too tough... \\ // <<No Vacancy>> \\// ...no fee too high! \\ ///////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\Received on Wed Jun 03 1998 - 21:36:59 CEST