Quote Originally Posted by ixion
Flat file creation is easy with, IxUnload: see www.ixionsoftware.com
It might be easier, but it's also more expensive, I'd say.

I wonder, why after the most elegant, most cost effective and most "native" solution has allready been proposed (i.e. davey23uk's suggestion to use 9i exp utility for export from 10g database and then 9i imp to imort into 9i database), new and new "smart" suggestions keep popping up.....

But hey, why do it simple and efficient when you can do it complicated and convoluted....