Re: Flatfiles from oracle tables

You might try a variation on this theme,

spool tmp1.tmp
select 'select * from '||table_name||';' from user_tables; spool off
spool output.out
start tmp1.tmp
exit

The concept is to select your output statements from the data dictionary, The above would be a bare-bones (not to useful as is) but you can get very sophisticated with your selects from the data dictionary. I have a com file on the vax that I can run with a table (or list of tables) that dumps a text file with an insert statement for every record in each of the table(s). We use that for purposes similar to what you are doing (granted we go database to database).

                               Craig