RE: Sybase tables

There was some development done here to move data between sybase to Oracle via C programs using both the Sybase "libraries" and Oracle PRO*C/OCI. Another option-but the dumping to a delimited flat file and using sql*loader seams more appealing..

greg

-----Original Message-----
From: Marina Leonardo, Jose Luis [mailto:JLMarina_at_uni2.es] Sent: Wednesday, June 21, 2000 8:08 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Sybase tables

Hi,

Yes you can use a Sybase utility to generate flat files, with <character> separate fields. The name of the utility is (I think) bcpout.

Also you can use some of the gateways products between sysbase and oracle databases.
This option is more *transparent* but prepare your self to empty your pockets.

HTH Joselu
www.OraEs.com
Madrid (SPAIN)

> -----Mensaje original-----
> De: Glen Braden [SMTP:g.a.braden_at_larc.nasa.gov]
> Enviado el: martes 20 de junio de 2000 23:20
> Para: Multiple recipients of list ORACLE-L
> Asunto: Sybase tables
>
> Does anyone have a technique to load sybase tables (data) into oracle
> tables?
>
> I am thinking that sybase must create a flatfile, and the flatfile is used
>
> by sqlloader.
>
> Is this correct?
>
> Glen A Braden g.a.braden_at_larc.nasa.gov
> DBA gbraden_at_visi.net
> ICQ#33298579
> (757) 865-8440 x130 http://sun1misb.larc.nasa.gov/bamis/
> (757) 865-6426 Fax ADABAS 6.2.1 NATURAL 2.2.8++ TRIM 6.1.0
> NCI Information Systems SUPERNATURAL 3.1.5 MVS/OS 390 CICS 4.3
> ORACLE 6 (don't Ask), ORACLE 7,
> ORACLE 8
>
> --
> Author: Glen Braden
> INET: g.a.braden_at_larc.nasa.gov
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: Marina Leonardo, Jose Luis
  INET: JLMarina_at_Uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may