Oracle导入导出
本地导出 ：exp idealims_jx/passw0rd@orcl owner=idealims_jx file=IdealIMS_JX_20110511.dmp远程导入: imp userid=idealims/imspassw0rd@134.224.55.12 full=y file=IdealIMS_JX_20110511.dmp
导出几张表 :
I:\>exp idealims/idealims@orcl
tables=IMS_OT_BUSINESS_LOG,IMS_OT_SYSTEM_CONFIG file=d:\tables.dmp
如果导出的用户名不一样，去掉加上fromuser=
如果是两个不同版本的数据库导入导出，用命令expdp 和impdp
expdp idealimsbt/idealimsbt dumpfile=idealimsbt_20091119.dmp
默认的导出位置 : D:\oracle\product\10.2.0\admin\orcl\dpdump
impdp idealims/idealims@BT_10.5.245.173 fromuser=idealimsbt dumpfile=idealimsbt_20091119.dmp
impdp idealims/idealims@BT_10.5.245.173 dumpfile=idealimsbt_20091119.dmp
页:
[1]