Re: Sybase tables

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 20 Jun 2000 23:08:31 GMT
Message-Id: <10534.109921@fatcity.com>

Glen,

Sybase has a data load/unload program called bcp. Use that (with the appropriate control file) to create a flat file that sqlldr can read.

Otherwise you can buy one of the gateway products that allow you to go directly from one to the other. But they cost.

Rachel

>From: Glen Braden <g.a.braden_at_larc.nasa.gov>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Sybase tables
>Date: Tue, 20 Jun 2000 13:19:51 -0800
>
>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).

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Tue Jun 20 2000 - 18:08:31 CDT