select/insert into/from a file ?

I need to move data from 1 database to another and need to do this using files. There are about 8 tables and the largest table has about 100 rows.

Is there a simple way to do this in Oracle ?

Informix makes this really easy:

    unload to x.dat select * from tableX     load from x.dat ....

Can I select * from table x into a file, and then insert from this file into the same table in another database ?

    thanks, Lisa Received on Fri Sep 01 2000 - 08:37:58 CDT