oracle - 导入导出dmp emp/imp;empdp/impdp

1.使用emp导出

exp {user}/{pwd}@{address}/{sid} file={path} owner={user}
exp {user}/{pwd}@{address}/{sid} file={path} owner={user} tables={table1}
exp {user}/{pwd}@{address}/{sid} file={path} owner={user} tables=({table1,table2,table3})

2.使用imp导入

imp {user}/{pwd}@{address}/{sid} file={path} full=y

3.使用empdp导出

expdp {user}/{pwd} direcotry=full dumpfile={directory} logfile={logfile} full=y  ----dumpfile和logfile绝对不能加路径

4.使用impdp导入

impdp {user}/{pwd}  schemas={user} directory={directory} dumpfile={path} logfile={log_path}