Re: Loading dBaseIV using the SQL*Loader?

"Georg Niemeyer" <niemeyer_at_uni-muenster.de> wrote in message news:a3q1aucch07db4vgfamjh6t64k415l0h14_at_4ax.com...
> Hallo everyone,
> I have to load dBase IV files into Oracle8i. Is this possible with the
> SQL*Loader? I tried to delete the header-informations and described in
> the ctl-file the positions of each column. The first row was read
> without any problems, but after this the loader stops.
> The log-file says nothing about an error, only that one row was
> successfully read.
>
> Thanks for trying to understand what I wrote and answering
>
> Georg
>

There used to be a special tool for this called db3prep but that has since long been deleted by Oracle.
The best solution looks like attaching the tables to an Access database, and exporting them to Oracle using the ODBC driver. I know for a fact this procedure works. Please avoid lowercase column names and whitespace characters in the original table names, the ODBC driver won't convert them.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address