设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › imp 全库导入时报错

imp 全库导入时报错

[复制链接]
查看11 | 回复5 | 2008-2-13 12:43:03 | 显示全部楼层 |阅读模式
imp system/xxxx@orcl file=d:\dump\full.dump ignore=y full=y
我从生产库exp全库导出
再在另一台服务器上安装了新的数据库
并建立了相应的数据文件目录和生产库上的用户，并且暂时都指定了dba权限给这些用户
然后执行上述命令进行导入结果报如下大量错误
Column 2 PRIORITY GROUP
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 1
Column 2 SITE PRIORITY
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 1
Column 2 USER FLAVOR FUNCTION
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 1
Column 2 USER FUNCTION
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 2
Column 2 APPEND SEQUENCE
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 2
Column 2 APPEND SITE NAME
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 2
Column 2 DISCARD
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 2
Column 2 USER FLAVOR FUNCTION
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 2
Column 2 USER FUNCTION
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 3
Column 2 USER FLAVOR FUNCTION
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 3
Column 2 USER FUNCTION
0 rows imported
. . importing table "REPCAT$_RESOLUTION_STATISTICS"
0 rows imported
. . importing table"REPCAT$_RESOL_STATS_CONTROL"
0 rows imported
. . importing table"REPCAT$_RUNTIME_PARMS"
0 rows imported
. . importing table
"REPCAT$_SITES_NEW"
0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "REPCAT$_SITES_NEW" ADD CONSTRAINT "REPCAT$_SITES_NEW_FULL_INST"
"" CHECK (full_instantiation IN ('Y', 'N')) ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table "REPCAT$_SITE_OBJECTS"
0 rows imported
. . importing table
"REPCAT$_SNAPGROUP"
0 rows imported
. . importing table "REPCAT$_TEMPLATE_OBJECTS"
0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_OBJECTS" ADD CONSTRAINT "REPCAT$_TEMPLATE_OBJ"
"ECTS_VER" CHECK (object_version# >= 0 AND object_version# = 0 AND object_version# < 65536) ENABLE N"
"OVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table "REPCAT$_TEMPLATE_PARMS"
0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_PARMS" ADD CONSTRAINT "REPCAT$_TEMPLATE_PARMS"
"_C1" CHECK (user_override in ('Y','N')) ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table "REPCAT$_TEMPLATE_REFGROUPS"
0 rows imported
. . importing table "REPCAT$_TEMPLATE_SITES"
0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_SITES" ADD CONSTRAINT "REPCAT$_TEMPLATE_SITES"
"_C2" CHECK ((site_name is not null and repapi_site_id is null) or"
" (site_name is null and repapi_site_id is not null)) ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_SITES" ADD CONSTRAINT "REPCAT$_TEMPLATE_SITES"
"_C1" CHECK (status in (-1,0,1)) ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table"REPCAT$_TEMPLATE_STATUS"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_TEMPLATE_STATUS_PK) violated
Column 1 0
Column 2 Modifiable
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_TEMPLATE_STATUS_PK) violated
Column 1 1
Column 2 Frozen
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_TEMPLATE_STATUS_PK) violated
Column 1 2
Column 2 Deleted
0 rows imported
. . importing table "REPCAT$_TEMPLATE_TARGETS"
0 rows imported
. . importing table "REPCAT$_TEMPLATE_TYPES"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_TEMPLATE_TYPES_PK) violated
Column 1 1
Column 2 Deployment template
Column 3 01
Column 4
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_TEMPLATE_TYPES_PK) violated
Column 1 2
Column 2 IAS template
Column 3 02
Column 4 0 rows imported
. . importing table"REPCAT$_USER_AUTHORIZATIONS"
0 rows imported
. . importing table "REPCAT$_USER_PARM_VALUES"
0 rows imported
. . importing table"SQLPLUS_PRODUCT_PROFILE"
0 rows imported
. importing OUTLN's objects into OUTLN
. . importing table
"OL$"
0 rows imported
. . importing table
"OL$HINTS"
0 rows imported
. . importing table
"OL$NODES"
0 rows imported
. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
. . importing table "AURORA$IIOP$SYSTEM$PROPERTIES"
0 rows imported
-------------------------
不知道该如何解决，大家能否给提示下
系统用户下的对象已经存在了，没事
回复

使用道具 举报

千问 | 2008-2-13 12:43:03 | 显示全部楼层
我imp之前只是建立了用户和数据文件的路径
并没有创建标空间和对应的数据文件
我imp结束后发现，新库里还是安装时默认的标空间和数据文件
没有发现一个导入的标空间和数据文件
难道是imp前应该先创建标空间和数据文件么？？？
大家怎么做的呢
回复

使用道具 举报

千问 | 2008-2-13 12:43:03 | 显示全部楼层
当然要先创建相应的表空间和用户了，不然导入到那里去啊？？
好好看一下imp和exp吧
回复

使用道具 举报

千问 | 2008-2-13 12:43:03 | 显示全部楼层
但是未知原数据文件大小情况下，该怎么创建数据文件，autosize么
另有一说为只设定数据文件路径即可imp全库，为何我能imp成功，却不见数据文件呢
回复

使用道具 举报

千问 | 2008-2-13 12:43:03 | 显示全部楼层
对象已经存在了
回复

使用道具 举报

千问 | 2008-2-13 12:43:03 | 显示全部楼层
ignore=y试试。
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行