Quote Originally Posted by jmodic
It might be easier, but it's also more expensive, I'd say.
More Expensive is a relative term wouldn't you say?

In this case I'd certainly use a dblink.. simple and easy for small data sets. I was mainly responding to dbasans post about a "flat file".

Export/import is fine for "small" data. But when it comes to large data loading nothing beats sqlldr VAR formatted data. Thats where this product fits nicely (sqlplus won't be able to create that type of file).

regards.