Oracle中exp导出,imp导入的使用详解
EXP:
- 完全(需要有特殊权限):
EXP SYSTEM/MANAGER BUFFER=64000 FILE=C:\FULL.DMP FULL=Y
- 用户模式(用户所有对象被输出到文件):
EXP SONIC/SONIC BUFFER=64000 FILE=C:\SONIC.DMP OWNER=chengwenit
- 表模式:
EXP SONIC/SONIC BUFFER=64000 FILE=C:\SONIC.DMP OWNER=CHENGWENIT TABLES=(CHW_USERS)
IMP:
- 完全:
IMP SYSTEM/MANAGER BUFFER=64000 FILE=C:\FULL.DMP FULL=Y
- 用户模式:
IMP chwit/chwit BUFFER=64000 FILE=C:\chwit.DMP FROMUSER=chw TOUSER=chwit
- 表模式:
imp system/manager file=tank log=tank fromuser=chengwenTABLES=(a,b)
EXP导出实例
exp system/manager@TEST file=d:\daochu.dmp full=y
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
exp system/manager@TEST file=d:\daochu.dmp tables=(table1,table2)
exp system/manager@TEST file=d:\daochu.dmp tables=(table1) query=\" where filed1 like '00%'\"
IMP导入实例
imp system/manager@TEST file=d:\daochu.dmp
imp system/manager@TEST file=d:\daochu.dmp tables=(table1)