This content has been marked as final.
Show 5 replies
-
1. Re: About Impdp
The Real Rob the Relic Jul 11, 2018 11:03 AM (in response to user639304)Check the oracle documentation for the query clause of impdp
-
2. Re: About Impdp
John Thorton Jul 11, 2018 12:59 PM (in response to user639304)user639304 wrote:
Is it possible to add this condition in the impdp command?
yes, it is possible
-
3. Re: About Impdp
dba.saravanan Jul 11, 2018 1:03 PM (in response to user639304)1 person found this helpfulHi,
FYR,
impdp scott/tiger directory=data_pump_dir dumpfile=scott_001.dmp schemas=movies query=movies.customer:\"where state='TX'\"
-
4. Re: About Impdp
SeánMacGC Jul 11, 2018 3:36 PM (in response to user639304)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 '\'.
-
5. Re: About Impdp
jgarry Jul 11, 2018 4:37 PM (in response to user639304)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;