我用imp system/gsbx@gsbx fromuser=gsbx touser=gsbx file=d:gsbx.dmp
运行之后,出现了以下提示:
import:release 10.2.0.1.0-production on sun jun 7 23:21:03 2009
copyright (c) 1982,2005,oracle. all right reserver
connected to :oracle database 10g enterprise edition release 10.2.0.1.0-production
with the partitioning,olap and data mining optionsExport file created by EXPORT:V10.02.01 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing GSBX's objects into GSBX
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.
请问这个是怎么回事啊???
运行之后,出现了以下提示:
import:release 10.2.0.1.0-production on sun jun 7 23:21:03 2009
copyright (c) 1982,2005,oracle. all right reserver
connected to :oracle database 10g enterprise edition release 10.2.0.1.0-production
with the partitioning,olap and data mining optionsExport file created by EXPORT:V10.02.01 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing GSBX's objects into GSBX
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.
请问这个是怎么回事啊???
要在目标库上建立touser里指定的user和相应的表空间==================================================================
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
电子邮件:[email protected]
网站: http://www.inthirties.com
我看到另外一个兄弟伙在导入的时候,好像没有建立user,直接将库创立好之后就导入系统了。
ORA-01435: user does not exist 用户不存在?
你的兄弟登陆的时候可能是用操作系统认证的方式登陆的吧,用system登陆的吧,这样就不需要创建用户了
imp system/gsbx@gsbx fromuser=gsbx touser=gsbx file=d:gsbx.dmp
用户名是system,密码是gsbx,数据库名是gsbx
grant dba to 用户名 //给新建的用户授dba权限