【示例】
1、【全库模式】将数据库orcl完全导出,用户名scott密码scott数据文件导出到D:/orcl/scott.dmp,日志文件到出到D:/orcl/scott.log
exp scott/scott@orcl file = D:/orcl/scott.dmp log = D:/orcl/scott.log full = y
2、【表模式】将数据库中的表emp、dept导出到D:/orcl/scott_empdept.dmp
exp scott/scott@orcl file = D:/orcl/scott_empdept.dmp tables = (emp,dept)
3、【用户模式】将243数据库中用户ng_lxj1和ng_lxj2的所有数据导出到D:/orcltest/ ng_lxj_user.dmp
exp system/manager@243 file = D:/orcltest/ng_lxj_user.dmp owner = (ng_lxj1, ng_lxj2)
4、将数据库中的表emp中SAL字段大于1000的记录导出到D:/orcl/scott_emp.dmp
exp scott/scott@orcl file = D:/orcl/sys_scott.dmp tables = (emp) query = \”where sal > 1000\”
5、将数据库中的表emp仅导出建表语句不导出数据行到D:/orcl/scott_empddl.dmp
exp scott/scott@orcl file = D:/orcl/scott_empddl.dmp tables = emp rows = n