How to fix the Oracle error EXP-00035: QUERY parameter valid only for table mode exports?

In this post, you’ll learn more about the Oracle ErrorEXP-00035: QUERY parameter valid only for table mode exports with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

EXP-00035: QUERY parameter valid only for table mode exports

Reason for the Error EXP-00035: QUERY parameter valid only for table mode exports

You specified the QUERY parameter in an export command, but you are not performing a table mode export. The QUERY parameter cannot be used for a user mode export, a full export, nor a point in time recovery export.

How to fix the Error EXP-00035: QUERY parameter valid only for table mode exports ?

You can fix this error in Oracle by following the below steps

If you want to select a subset of rows for a table, you must export the table independently with a table mode export. Issue a table mode export command that specifies the table name and the query you want to execute during export.