RE: Sybase tables

faster too :) as you don't have to write code

>From: "LoughMiller, Gregory" <Gregory_LoughMiller_at_bscc.bls.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Sybase tables
>Date: Wed, 21 Jun 2000 04:48:50 -0800
>
>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-----
>Sent: Wednesday, June 21, 2000 8:08 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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
>also send the HELP command for other information (like subscribing).
>--
>Author: LoughMiller, Gregory
> INET: Gregory_LoughMiller_at_bscc.bls.com
>
>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).