Re: How to move data from Oracle to flat files

I don't have any experience doing this and there is probably a better way but... you could use the DBMS OUTPUT procedure (I think set server output needs to be ON in your login.sql file) to dump all the rows into a spool file
ie: SPOOL flatfile.txt
open cursor to read db
dbms_output (col1 || col2 || col3...)
SPOOL OFF OR what about the Oracle export utility?? I have never used it.

Good Luck!

Neelufar Hasan wrote:
>
> 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 Sat Nov 08 1997 - 00:00:00 CET