Oracle export and import tool script

This is an operation to export all objects under the user's ebmall to the ebmall. dmp file under the test directory. The recorded log file is ebmall. log.

Expdp xxyy/xxyyp schemas = ebmall directory = test dumpfile = ebmall. dmp logfile = ebmall. Log

Impdp system/CMDL directory = xxyy dumpfile = xxyy. dmp logfile = xxyy. Log

If the DMP file of the source database is another user exported by the System user, add the schemas option to specify the user to import.

If the user exporting the DMP file is xxyy, We need to execute the schemals parameter value during import.

The usage is as follows:

Impdp system/CMDL directory = xxyy schemas = ebmall dumpfile = ebmall. dmp logfile = ebmall. Log