It is REALLY easy if you use SQL-Worksheet or TOAD. You use those? Those GUIs will take a table and save it as a .csv file.

Basically, send the table from DB A to a .CSV file. From there you can use SQLLOADER to insert the data to DB B with a .ctl file to position your column inserts.

Questions?

- Magnus