Re: Paradox to Oracle migration ! Any advice please

> I have an application that uses paradox tables but suffers from corrupt
> indexes occasionally. I am therefore looking for an alternative.
>
> The program is written in Delphi 3
>
> I'd appreciate any comments on Speed, migration, code problems

Speed in Oracle will be very substantially faster if you set up the database correctly. To migrate your data use Paradox (the database) to either perform insert queries directly into the Oracle tables or export the data to an ASCII file and then use SQL*Loader to load the ASCII files.

I don't understand what you might be inferring with respect to code problems but can advise you to move as much of your logic into database packages and stored procedures as possible to gain a major performance improvement.

Daniel A. Morgan Received on Thu Nov 26 1998 - 18:37:00 CET