![](https://img.codepudding.com/202009/111235271821591.png)
Import impdpxxxxx. The content of the bat:
Rem drop user ogisbase1 cascade;
Impdp userid='workFlowDt/workFlowDt @ wouldn' directory=DATA_PUMP_DIR dumpfile=workflowdt0921. DMP logfile=workflow. The log SCHEMAS=workflow table_exists_action=replace
Pause
Directory:
![](https://img.codepudding.com/202009/111235271821592.png)
CodePudding user response:
Expdp command, is how to write?CodePudding user response:
Expdp command:![](https://img.codepudding.com/202009/111235271821593.png)
CodePudding user response:
Changing SCHEMAS=workflowDt reasons: when the user does not agree with to import a user name, a workflowDt a SCHEMAS=workflow