DataPump Worker (DW) Processes Do Not Work Concurrently To Import Data Into Pre-Created Tables

(Doc ID 2317768.1)

Last updated on OCTOBER 31, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


When trying to load data in parallel mode using DataPump import (impdp):

In 10g multiple worker processes can concurrently work at the same time.
In, we can see multiple work processes can concurrently work to load data if tables have NOT been pre-created, but a different behavior is seen when the tables are pre-created before the import.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms