Expdp query usage

Expdp Scott/tiger directory = DP tables = T1 schemas = Scott dumpfile = t1.dmp logfile = t1.log query = '"where hiredate> to_date ('2017-01-02 ', 'yyyy-mm-dd ')"'

 

C: \ Users \ Administrator> expdp Scott/tiger directory = DP tables = Scott. T1 dumpfile = t1.dmp logfile = t1.log query = "where hiredate> '2017-01-02 '"

Export: Release 11.2.0.1.0-production on Monday March 11 15:42:54 2013

Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the partitioning, OLAP, data mining and real application testing options
ORA-39001: Invalid parameter value
ORA-39035: The data filter subquery has been specified.

It indicates that there is a problem with query writing.

Correct writing should use \ escape quotation marks

C: \ Users \ Administrator> expdp Scott/tiger directory = DP tables = T1 dumpfile = t1.dmp logfile = t1.log query = t1: \ "where hiredate> to_date ('2017-01-02 ', 'yyyy-mm-dd ')\"

Export: Release 11.2.0.1.0-production on Monday March 11 16:33:45 2013

Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the partitioning, OLAP, data mining and real application testing options
Start Scott ". "sys_export_table_01": Scott/******** directory = DP tables = T1 dumpfile = t1.dmp logfile = t1.log query = t1: "Where hiredate> to_date ('1970-01-02 ', 'yyyy-mm-dd ')"
Using the blocks Method for estimation...
Processing object type table_export/table/table_data
Total estimation using the blocks method: 64 KB
Processing object type table_export/table
.. Exported "Scott". "T1" 8.304 kb 8 rows
The master table "Scott". "sys_export_table_01" is successfully loaded/uninstalled"
**************************************** **************************************
The dump file set of Scott. sys_export_table_01 is:
E: \ oracle \ t1.dmp
The job "Scott". "sys_export_table_01" was successfully completed at 16:33:59.

Impdp Scott/tiger directory = DP remap_table = t1: T2 dumpfile = t1.dmp logfile = t2.log table_exists_action = replace

 

 

 

When multiple tables are created:

Query = EMP: \ "where username in ('aaa', 'bb') \", Taba: \ "where rownum <5 \"