oracle导入导出

exp tuser/cabletech@10.230.60.247/orcl file = d:\exp.dmp tables=(JL_JF_DETAIL) query = \"where oildate like '2016%'\"




exp tuser/cabletech@10.230.60.248/orcl file = d:\exp.dmp tables=(aaaa)



imp tuser/cabletech@10.230.60.248:1521/orcl file=d:\exp.dmp log=d:\exp.log fromuser=tuser touser=tuser constraints=N ignore=y


imp tuser/123456@127.0.0.1:1521/orcl file=E:\代维数据库\tuser7.dmp ignore=y tables=(JL_PBOSSNWG_NUM)

上一篇:最全的Oracle数据库备份与还原命令


下一篇:Oracle导入、导出数据库dmp文件 版本