Slow DataPump Import (IMPDP) With Multiple REMAP_TABLESPACE
Last updated on SEPTEMBER 05, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
The following symptoms are observed:
- importing metadata/data of a partitioned table(s) with a large number of partitions (in current scenario more than 12000 partitions) is slow;
- more than 600 REMAP_TABLESPACE are in the parfile;
- manually creating the table in SQL*Plus takes less than 1 minute.
Migrated a partitioned table to a new database, but into different tablespaces.
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