EXP

１．导出ｍｇｎ用户下所有对象

exp mgn/mgnp owner=mgndb rows=y compress=n buffer=65536 feedback=100000  file=D:\ORA_DATA\test.dmp log=D:\ORA_DATA\test.log

 

２．导出表dept_external

exp system/manager owner=mgn rows=y compress=n buffer=65536 feedback=100000  file=D:\ORA_DATA\dept.dmp log=D:\ORA_DATA\dept.log tables=(dept_external)

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
EXP-00026: 指定了冲突模式
EXP-00000: 导出终止失败

 

 

--解析

owner=mgn
tables=(dept_external)

这个冲突了，你只能选择按库、用户、或表之一进行export，而不能象你那样即按用户又按表进行export

 

exp system/manager rows=y compress=n buffer=65536 feedback=100000  file=D:\ORA_DATA\dept.dmp log=D:\ORA_DATA\dept.log tables=(dept_external)