Check the oracle documentation for the query clause of impdp
Is it possible to add this condition in the impdp command?
yes, it is possible
1 person found this helpful
impdp scott/tiger directory=data_pump_dir dumpfile=scott_001.dmp schemas=movies query=movies.customer:\"where state='TX'\"
Hello, what might help you here is to use a a parameter file, parfile = <your_par_file>, which would mean that you have no need to escape any characters on the command line with '\'.
You also might want to consider the ANSI date specification, so you don't run into potential NLS issues.
select DATE '2018-06-30' from dual;