oracle 导出dmp数据: exp usernmae/password@ip:host/instantname file=f:\daochu.dmp owner=( tablespacename ) 导入dmp数据: imp username/password@ip:host/instancename full=y file = d:\data\daochu.dmp ignore=y 注意:不用进sqlplus. 以上是直接导出/导入表空间所以表结构和表数据