导出:
只导出表结构:
exp xubaouser/Xubao!230Yonghu@9.23.2.213:1521/nxubaodb file=lyt.dmp rows=n
表结构表数据一起导入的:
exp userid=xubaouser/Xubao!230Yonghu@9.23.2.213:1521/nxubaodb owner=xubaouser file=d:/daochu.dmp
导出指定表的表结构
exp xubaouser/Xubao!230Yonghu@9.23.2.213:1521/nxubaodb file=branch.dmp statistics=none TABLES=(t_branch)
导入:
imp gpp/123456@localhost:1521/orcl file=branch.dmp fromuser=xubaouser touser=gpp ignore=y