This content has been marked as final. Show 2 replies
I can see the degree in DBA_DATAPUMP_JOBS and the corresponding sessions. Can I update this Data Pump table to reduce the number of sessions created by Data Pump? What comes to mind is by updating the DEGREE column, but it seems risky.You should not be updating any data pump table.
You can use command line interface and connect to the import session doing the job.
impdp -help (look at the bottom section)
The following commands are valid while in interactive mode. Note: abbreviations are allowed.
PARALLEL: Change the number of active workers for current job.
I have not done it but it seems the parameter PARALLEL can help you.
Perfect, thank you.
It did not solve the problem of slow index importing, but it is correct :-)