Toad World® Forums

Export Table as Flat File - Automating the process?


Is it not possible to automate the “Export Table as Flat File” process in Toad for Oracle

More specifically, I am looking for a way to automate the generation/saving of the Specification File for every table in a schema.


Look at Export Dataset with the “Fixed Field Spacing” format. It doesn’t use the specification file. Field spacing is based on table DDL. If I remember correctly, the “Include a space between fields” option will make the files have the same field sizes as “Export to flat file”.

Thanks for the info, that’s what I’ve used to get the data files, however the request I am working on asked a simple specification file too, not actual Oracle DDL scripts.

Oh, I see. Sorry, there’s no way to auto-generate a bunch of spec files like that.