免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3269 | 回复: 2
打印 上一主题 下一主题

如何从异构环境下9i到10G的迁移? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2012-02-06 09:05 |显示全部楼层 |倒序浏览
目前要完成一项任务,从windows环境下的9i把数据迁移到AIX下的10GR2。
数据已经从9i上exp出来了,用SYS用户加full=y参数。
在imp到10G时报了很多错。
10G的环境需要怎么准备呢?谢谢

论坛徽章:
0
2 [报告]
发表于 2012-02-06 11:04 |显示全部楼层
我有一点搞不清楚,因为之前数据库是厂家布置的,不清楚有几个用户需要导出。所以我用的是FULL导出。
另外问一点,在导入数据之前要不要先建好表空间?还是在导入数据时会自动建表空间?

论坛徽章:
0
3 [报告]
发表于 2012-02-07 00:13 |显示全部楼层
试过楼上二位的作法,依然不行,提示:
ORA-01917: user or role 'EIPWEB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "ITSM""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ITSM' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "EIPPORTAL" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'EIPPORTAL' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "EIPWEB" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'EIPWEB' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "EAI" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'EAI' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ITSM" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ITSM' does not exist
. importing WMSYS's objects into WMSYS
. importing WKSYS's objects into WKSYS
. importing ODM's objects into ODM
. importing OLAPSYS's objects into OLAPSYS
. importing HR's objects into HR
. importing OE's objects into OE
. importing QS's objects into QS
. importing QS_WS's objects into QS_WS
. importing QS_ES's objects into QS_ES
. importing QS_OS's objects into QS_OS
. importing QS_CBADM's objects into QS_CBADM
. importing QS_CS's objects into QS_CS
. importing RMAN's objects into RMAN
. importing BBS's objects into BBS
. importing BBSCS's objects into BBSCS
. importing EIPPORTAL's objects into EIPPORTAL
"ALTER SESSION SET CURRENT_SCHEMA= "EIPPORTAL""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
$
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP