Toad World® Forums

Export Table as Flat File - Automating the process?


#1

Hello,

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

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

Thanks,
Jeff


#2

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”.


#3

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.


#4

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