导出
一张表
exp username/password@127.0.0.1:1521/orcl file= /home/oracle/tmpfile/xxxxtmp.dmp tables=table1
exp 用户名/密码@IP:1521/实例名 file=dmp文件全路径 tables=指定导出表名
多张表
exp username/password@127.0.0.1:1521/orcl file= /home/oracle/tmpfile/xxxxtmp.dmp tables=table1,table2;
全部表
exp username/password@127.0.0.1:1521/orcl file= /home/oracle/tmpfile/xxxxtmp.dmp
导入
imp username/password@127.0.0.1:1521/orcl file= /home/oracle/tmpfile/xxxxtmp.dmp ignore=y full=y;
解释同理(exp)