Quote Originally Posted by dbasan
10g data > flat file > sql loader, dump in 9i.
Flat file creation is easy with, IxUnload: see www.ixionsoftware.com

Then use sqldr on your 9i system to reload the data. For large amounts of data, sql Loader (direct) is faster.