Multiple table export in oracle

Question

Is it possible to export multiple tables in oracle using QUERY parameter the WHERE clauses are different for each table?

Answer 1

If you're using the old export (exp) then no, you'd need to do a separate export for each table. The restrictions are shown in the documentation.

If you're using data pump (expdp) then yes, you can specify multiple QUERY clauses and specify which table each applies too, again as described in the documentation.