Automate Table Export

[GRAYTech]

Is there a way to automate exporting tables using the T)ools, E)xport Tables menu option?

I've tried the macro recorder with limited success. I need select a bunch of tables, specify the where clause, output file etc.

Ideally, there should be some way to save all the options to a file, then open the file to do the same export again at a later date.

Thanks.

 

[Tim Scott]

I think we probably need some more information, such as:
What are you trying to achieve?

You can script Oracle Exports using exp or expdp.

You can write your own SQL exports to file - although that will take a little time to refine.

Regards,