新安装了centos5.5,安装好了oracle10g ,现在将备份数据库导入,语句如下:
imp xhsd_jcd/jcd file=(1.dmp,2.dmp,3.dmp,4.dmp) filesize=3000m
log=imp3.log fromuser=xhsd_jcd buffer=20000000原先导出来的语句是在 windows2000下
exp xhsd_jcd/jcd@XHSD_JCD Owner=XHSD_JCD File=(F:\backup_jcd\1.dmp,F:\backup_jcd\2.dmp,F:\backup_jcd\3.dmp,F:\backup_jcd\4.dmp,F:\backup_jcd\5.dmp) filesize=3000m buffer=20000000 Log=F:\backup_jcd\Exp.log现在导入的时候出现
syntax error near unexpected token '('
望高手指导一下。
imp xhsd_jcd/jcd file=(1.dmp,2.dmp,3.dmp,4.dmp) filesize=3000m
log=imp3.log fromuser=xhsd_jcd buffer=20000000原先导出来的语句是在 windows2000下
exp xhsd_jcd/jcd@XHSD_JCD Owner=XHSD_JCD File=(F:\backup_jcd\1.dmp,F:\backup_jcd\2.dmp,F:\backup_jcd\3.dmp,F:\backup_jcd\4.dmp,F:\backup_jcd\5.dmp) filesize=3000m buffer=20000000 Log=F:\backup_jcd\Exp.log现在导入的时候出现
syntax error near unexpected token '('
望高手指导一下。
log=imp3.log fromuser=xhsd_jcd buffer=20000000
是不是应该把这个file后面的,去掉呢。
imp xhsd_jcd/jcd file='(1.dmp,2.dmp,3.dmp,4.dmp)' filesize=3000m
log=imp3.log fromuser=xhsd_jcd buffer=20000000