As mentioned you would just use the tables=(table1, table2,...,tablen) option in export. generating this list shouldn't be too hard.

I'm not sure if you could do it in one oracle query, but with one query (depending on layout) you can get a list of all the tables you want to export into a file, like this

TABLE1
TABLE2
TABLE3

then use a shell/perl script to read each line of of the table and create a statement like

tables=(table1,table2,...,tablen)

on one line, and print out any other export lines into a file, and use that as your parameters table.

if you have the list of files in say tables.lst, a quick perl script would be something like below. It may not be the "easiest" way to accomplish the job but it would get it done without too much work.

<font face="courier">
#!/usr/bin/perl

open (TABLES, tables.lst');
$table_param = "tables=(";

while( $next_table = &lt;TABLES&gt; ) {
chomp; # removes the newline character, other whitespace shouldn't cause a problem
$table_param .= "$next_table,";
}
chop; # remove the comma from the last table
$table_param .= ")";

# at this point, $table_param = "tables=(table1,table2,...,tablen)"
# now just print it out, and other parameters to a file
open (PARAMS, "export.params");
print PARAMS "file=mydump.out\n";
print PARAMS "full=n\n";
# whatever other parameters you want
print PARAMS "$table_param\n";

close(PARAMS);
close(TABLES);
</font>

Now there's a file called export.params with the table list and whatever else you added.