Sunday , June 16 2024

Oracle Data Pump Query Parameter


With the data pump, you can use the query parameter to export only the records that are returned from the query in a table. I wanted to share this parameter because it was very useful.

In this way, we can export only a required part of a large table and import it with this data.

Example use is as follows:

In the example, the records of the “dept_id” value in the emp table greater than 10 and the “sal” value greater than 10000 will be exported. Other records will not be included in export.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *