expdp报ora-21780。规避措施：expdp在运行时，请不要

expdp报ora-21780。规避措施：expdp在运行时，请不要改变参数值，比如parallel参数值，filesize参数值等等。，expdpora-21780

expdp在运行时，请不要改变参数，比如parallel参数值，filesize参数值，

否则可能会导致ora-21780错误。

Data Pump Export (expdp) or Data Pump Import (impdp) reports ORA-21780 at the end of export completion. (Doc ID 1357811.1)

在该文章中，对触发ora-21780的动作做了一个描述：

Changes

Changed number of parallel processes while Data Pump Export or Import was running.

Export> parallel=1
Export> exit

Solution

FIX

• 11.2.0.4
• 12.1

WORKAROUND

Don't change the number of parallel processes while Data Pump Export is running.

References

BUG:10198387 - DATA PUMP EXPORT REPORTS ORA-21780 WHEN PARALLELISM (PARALLEL=N) IS MODIFIED

SCHEMAS参数中只写一个，
如果还要转换用户名，在REMAP_SCHEMA参数中，只写一个用户就可以了。比如在REMAP_SCHEMA=USERA:USERB
 

参数exclude:
exclude=object_type[:name_clause][,...]
比如：impdp user/pass DIRECTORY=dmpdir DUMPFILE=user.dmp exclude=PROCEDURE:"in('p1', 'p2')",TABLE_STATISTICS