怪哦, 我在12机器上执行:exp mm/nnn file=mydata.dmp tables=xzkhzs1 该语句成功了, 但在15机器上执行:imp aa/bbb file=mydata.dmp full=y ignore=y(在15机器上没建表,即使建了表,也是类似这样的错误提示) ,执行的时候提示: mport: Release 9.2.0.4.0 - Production on Fri Feb 18 09:19:20 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. IMP-00058: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist HP-UX Error: 2: No such file or directory IMP-00005: all allowable logon attempts failed IMP-00000: Import terminated unsuccessfully lbas@zhjf $imp lbas/www.zw04 file=mydata.dmp full=y ignore=yImport: Release 9.2.0.4.0 - Production on Fri Feb 18 09:20:16 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. IMP-00058: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist HP-UX Error: 2: No such file or directory IMP-00005: all allowable logon attempts failed IMP-00000: Import terminated unsuccessfully请问是那里原因?
12:exp user/password tables=mytable15:imp user/password full=y是否写的语句这样理解:
对于12机器上,执行:exp user/password tables=mm_test;这里倒出的应该是一个文件吧?
在 15机器上,执行:imp user/password full=y ,这里应该理解成是把数据倒进库里吧?这里full=y怎么理解?
拷贝数据文件 这里拷贝数据文件是怎么个意思,怎么操作?
exp user/password file=mm.dmp tables=mm_test
imp user/password@15 file=mm.dmp tables=mm_test
如果15已经建立了表结构,则加入:ignore=y注意:版本的问题
full=y 主要是免除限制,把整个dmp文件灌入用户,有时可以理解为12机器上用户名是A,15机器上用户名是B,可以不考虑用户是否一致
ignore=y 主要是忽略创建错误,可以理解为强行创建对象具体参数你可以参考
x:/>imp help=yx:/>exp help=y这两个dos命令里面很详细地说明了各参数的作用
我在12机器上执行:exp mm/nnn file=mydata.dmp tables=xzkhzs1 该语句成功了,
但在15机器上执行:imp aa/bbb file=mydata.dmp full=y ignore=y(在15机器上没建表,即使建了表,也是类似这样的错误提示) ,执行的时候提示:
mport: Release 9.2.0.4.0 - Production on Fri Feb 18 09:19:20 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
IMP-00058: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully
lbas@zhjf $imp lbas/www.zw04 file=mydata.dmp full=y ignore=yImport: Release 9.2.0.4.0 - Production on Fri Feb 18 09:20:16 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
IMP-00058: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully请问是那里原因?
imp user/password@别名 file=mm.dmp tables=(table1,table2,----) ignore=y
实例没有启动,你可以通过system帐号 as sysdba登陆,并startup实例