本帖最后由 crazyboytan 于 2013-10-29 09:36 编辑
数据库环境为 windows oracle 11.2.0.3.0
客户端为11.2.0.1.0
在导入数据时报如下错误:
C:\Users\Bill>imp scott/tiger@xxxxxxxx:1521/xxx file=d:\orabak\X501-1_2.dmp fromuser=scott touser=scott ignore=y
Import: Release 11.2.0.1.0 - Production on 星期二 10月 29 09:20:57 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
经由常规路径由 EXPORT:V10.02.01 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 CJCL 的对象导入到 CJCL
. . 正在导入表 "GH_BB_BBZC"导入了 1 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "GH_BB_BBZC" ADD SUPPLEMENTAL LOG GROUP "TSORA16141274_0" ("REP"
"ORTID", "BH", "DCFFFLDM", "BBZWQC", "BBYWQC", "BBZWJC", "BB", "BBLX", "ZYFL"
"DM", "ZGZY", "TBSM", "WH", "DCNR", "DCPDDM", "DCPDMS", "QYSJ", "TYSJ", "YXQ"
"Z", "BBSX", "TXSJ", "TXSJMS", "BBZTDM", "BBJB", "SPR", "SPJG", "PZHJG", "PZ"
"WH", "BAJG", "BAWH", "ZBJG", "GLJG", "GLJGFZR", "WLBMC") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "GH_BB_BBZC" ADD SUPPLEMENTAL LOG GROUP "TSORA16141274_1" ("BZ""
", "BZH", "CJR", "CJSJ", "XGR", "XGSJ", "TJSPSJ", "SFYXJZLSSJ", "BBBGSM", "Q"
"ZBH", "SYBBID", "SQBID", "TQBH", "LSBZ", "TJDCDXJBLXDM", "DCLYLX", "BDCML","
" "MS", "SPYJ", "BFGBBID", "SCBZ", "SFKWHTBFW", "HZSJLS", "GZBBBM", "GZMLBM""
", "SJYLX", "CJBM", "BBCJSJ", "XDR", "XDSJ", "XDSM", "BBSM", "TBFW") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "GH_BB_BBZC" ADD SUPPLEMENTAL LOG GROUP "TSORA16141274_2" ("BBQ"
"BDM", "SSRW", "TBSJSM", "BBSYHY", "HZSYJGDM", "QSFS", "NBBS", "HZBLX", "SJC"
"JFS", "BBFL", "HZBSJBB", "BBZLDM", "DCDXLXDM", "TBDYFW", "TBHYFW", "DCDWSL""
", "BSDW", "BSDWLXDM", "BSFSDM", "HZFSDM", "RE_REPORTID", "SFTB", "TJZYDM", "
""SFGLB", "SFFRB") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
. . 正在导入表 "GH_BB_XY"导入了 18 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "GH_BB_XY" ADD SUPPLEMENTAL LOG GROUP "TSORA447996846_0" ("XYZB"
"", "REPORTID", "XORY", "ZBID", "ZBDM", "ZBZWM", "ZWJC", "MLID1", "MLXDM1", "
""MLID2", "MLXDM2", "MLID3", "MLXDM3", "ZBSJSDLXDM", "XYZB1", "XH", "BYDM", "
""FQH", "SJBLX", "HBXMS") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
. . 正在导入表 "GH_GZ_GZ"导入了 15 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "GH_GZ_GZ" ADD SUPPLEMENTAL LOG GROUP "TSORA53081821_0" ("GZID""
", "SHFSDM", "GZLXDM", "GHZTDM", "REPORTID", "GZYTFLDM", "GZJB", "GZQZXDM", "
""GZMC", "GZZW", "GZBDS", "GZCFTJ", "GZQYSJ", "GZTYSJ", "CWXX", "GLJGFZR", ""
"SPR", "SPJG", "CJR", "CJSJ", "XGR", "XGSJ", "TJSPSJ", "GLJG", "SFYX", "GZQX"
"DM", "LSBZ", "BZ", "XSGZBDS", "XSCWXX", "CJBM", "ZYY") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
. . 正在导入表 "GH_BB_TBDCDXLX"导入了 1 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "GH_BB_TBDCDXLX" ADD SUPPLEMENTAL LOG GROUP "TSORA908321946_0" "
"("REPORTID", "TJDCDXJBLXDM", "SFJBQKDC", "SJCCFS") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
. . 正在导入表 "CJ_DX_DCDXZBZDDZ"导入了 0 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "CJ_DX_DCDXZBZDDZ" ADD SUPPLEMENTAL LOG GROUP "TSORA509338250_0"
"" ("TJDCDXJBLXDM", "DYWLBM", "REPORTID", "DYWLBZDC", "ZBID", "TJDCDXJBLXMC""
", "ZBDM", "ZBBB", "ZBZWQC", "DYBM", "DYBH", "CJR", "CJSJ") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
. . 正在导入表 "WL_CC_DYGDYZDGX"导入了 18 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "WL_CC_DYGDYZDGX" ADD SUPPLEMENTAL LOG GROUP "TSORA815192999_0""
" ("REPORTID", "XZB", "YZB", "WLBM", "ZDMC") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
. . 正在导入表 "WL_CC_SJBDYBDGX"导入了 1 行
IMP-00017: 由于 ORACLE 错误 30567, 以下语句失败:
"ALTER TABLE "WL_CC_SJBDYBDGX" ADD SUPPLEMENTAL LOG GROUP "TSORA580536639_0""
" ("WLBM", "REPORTID", "BH", "BB", "TJJGDM", "TJJGJBDM") ALWAYS"
IMP-00003: 遇到 ORACLE 错误 30567
ORA-30567: 名称已被一现有日志组占用
成功终止导入, 但出现警告。
有没有遇到过的朋友帮看看!