Re: Sybase to Oracle Conversion

try bcp from sybase. It does the job sql-loader does for Oracle.

I thin it best fits writing all columns as character data & load it with parameter file into oracle tables

regards
Bernd Grandt at DG_HYP.de

Kevin L. Kitts <kkitts_at_his.com> wrote in article <kkitts-0401981306480001_at_kkitts.his.com>...
> Hello,
> I am in the process of converting a Sybase database (PCDOCS is the
> application I am converting) to an Oracle database. I am an experienced
> Oracle DBA - unfortunately my knowledge of Sybase is limited. Has anyone
> here done such a conversion and if so do you know of any tools that can
> easily extract the data from the 66 tables I am converting and perhaps
> write the control files for SQL*Loader (which I plan to use to import the
> data into Oracle)?
>
> Any tips or techniques would be most apprec.
>
> Thanks,
>
> Kevin
>
  Received on Mon Jan 05 1998 - 00:00:00 CST