About Impdp

user639304 Jul 11, 2018 10:40 AM

Hello Experts,

I has an expdp dump file, named ERP.DMP, of a schema ERP from an Oracle Database named PROD. In this ERP schema, there is a table orders with 150 millions rows, and a there is a column do (of type date). Now, using impdp, I would want to import ERP.DMP in the ERP schema of a database named TEST. But I would want that during the import process of the table orders, only the rows verifying dco > to_date('30/06/2018','dd/mm/yyyy') be imported. Is it possible to add this condition in the impdp command?

Thanks.

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
3. Re: About Impdp

dba.saravanan Jul 11, 2018 1:03 PM (in response to user639304)

Hi,

FYR,

impdp scott/tiger directory=data_pump_dir dumpfile=scott_001.dmp schemas=movies query=movies.customer:\"where state='TX'\"
1 person found this helpful
Like Show 0 Likes(0)

Actions
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 '\'.
Like Show 2 Likes(2)

Actions
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;
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.