Re: How to move data from Oracle to flat files

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_at_elektrosoft.se

Neelufar Hasan <Neelufar_hasan_at_mail.und.nodak.edu> wrote in article <3464B93F.42A734_at_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_at_mail.und.nodak.edu
>
>
>
Received on Tue Nov 11 1997 - 00:00:00 CET