From: "Peder Holst" <pederh@elektrosoft.se>
Subject: Re: How to move data from Oracle to flat files
Date: 1997/11/11
Message-ID: <01bceec6$3c10cac0$1a0a0a0a@pederh>#1/1
References: <3464B93F.42A734@mail.und.nodak.edu>
Organization: ElektroSoft AB
NNTP-Posting-User: s-14508
Newsgroups: comp.databases.oracle.tools



Neelufar,
One answer to this question is to use a smart
replication/transfer and conversion tool for use between Oracle and
textfiles, DB2/400, DB2/2, SQLServer and every other datasource you
can reach using 32-bit ODBC. Check out and download from
http://www.sqlmover.com. In you case - install your Intersolv
(www.intersolv.com) Oracle 32-bit ODBC driver if you haven't already and
use Intersolv or MS ODBC driver for text
files.The MS version can be downloaded from the same place as SQLMover.
Feel free to use any kind of field separator. Once done with this - choose
a table or write a
query against Oracle Now go to the mappings tab and
press GUESS. save and execute. Shouldn´t take more than 2 minutes to set
up. Full error control included.
Should you want to do something else while the query(ies) or table(s) are
being replicated - just set the scheduler to do the job. An evaluation key
for the full fledged version of SQLMover is 1KKJBFJYF. 
Regards,
Peder Holst
pederh@elektrosoft.se

Neelufar Hasan <Neelufar_hasan@mail.und.nodak.edu> wrote in article
<3464B93F.42A734@mail.und.nodak.edu>...
> We have Oracle and Adabas databases in our organizations.  We need to
> send data from Oracle to Adabas and vice versa.  I believe we could use
> SQL*LOADER to load data into oracle from ADABAS flat files.  But how
> could I transfer data from Oracle to flat files? If I could load data to
> flat files then we could load these data to ADABAS files easily.  Your
> help, suggestions would be greatly appreciated.  Please reply to my
> e-mail address.
> 
> Thanks,
> Neelufar
> 
> Email:
> Neelufar_hasan@mail.und.nodak.edu
> 
> 
>