1、导出带表的dmp
exp username/password@ip:1521/orcl file='/application/test.dmp' tables=(test)
2、导出全部表结构和数据
exp username/password@ip:1521/orcl file='d:/test.dmp' full=y
3、导入数据
imp username/password@ip:1521/orcl file='c:test.dmp' log='c:/test.log' full=y
1、导出带表的dmp
exp username/password@ip:1521/orcl file='/application/test.dmp' tables=(test)
2、导出全部表结构和数据
exp username/password@ip:1521/orcl file='d:/test.dmp' full=y
3、导入数据
imp username/password@ip:1521/orcl file='c:test.dmp' log='c:/test.log' full=y
