Extracting data from tables

I am in the process of moving our OracleRDB to Oracle9i on a WinXP server, for that I need to reproduce a functionality given in RDB: rmu/extract. What this does basically, is that it provides me with a flat/ASCII file with the contents of the desired table, having the columns enclosed in a selectable character.

I've taken a glimpse at the exp functionality, but it seems to me, to be exporting in binary format, suitable for reloading in another Oracle database.

I am aware, that I could select the table in sql-worksheet and copy/paste it to a txt file, but the process has to run without human intervention every night.

Any help would be highly appreciated -I am probably missing the obvious answer/utility, but neither metalink nor TechNet could provide me with anything useful.

Tia,

Kim Brandt Jensen

Danish Confedration of Trade Unions Received on Tue Sep 10 2002 - 11:38:53 CEST