How To Transfer Data From Tables Which Contain Specific Columns And Certain Data, Using DataPump (Doc ID 2240232.1)

Last updated on AUGUST 04, 2018

Applies to:

Goal

We want to export data for tables with columns ORGID, ORGNID (name made generic for this example) and with name ABC, HIJ, XYZ
with corresponding ORAGID/ ORGNID.

For example:

For name ABC, ORGID/ ORGNID can be 6760, 6758, 6759, 2181.
For name HIJ, ORGID/ ORGNID can be 6038, 2969, 2968.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.