Is it possible to call the plsql export/import commands from a procedure? I need to unload large amounts of data from another database and import it into my active one daily.
I was referring to the export/import commands available from the tools menu. Ideally I would like to export an ascii fixed field file. I could then use SQL Loader on the receiving end. I think this is the best option for performance, although I've been wrong before .