Originally posted by stecal
Interesting question. Almost. Export is a logical backup, you export various objects, not data returned from a query. You can specify the tables - and you have to specify them - not specify/return them as a result of a query.

exp via command line input or parameter file - how would/could you use a select statement as a parameter?
I thought he wanted to add a query into the export parfile, as per 8i, I'm not sure if there is a limit on this parameter.
Whoops, I just found this...


Restrictions
The parameter QUERY cannot be specified for full, user, or transportable tablespace mode exports.

The parameter QUERY must be applicable to all specified tables.

The parameter QUERY cannot be specified in a direct path export (DIRECT=Y)

The parameter QUERY cannot be specified for tables with inner nested tables.

You will not be able to determine from the contents of the export file whether the data is the result of a QUERY export.

MH