- 浏览: 159432 次
- 性别:
- 来自: 杭州
最新评论
-
逆风翔:
逆风翔 写道怎么分割split() split(str1) ...
arcII码为0x01,0x02作为分隔符 -
逆风翔:
怎么分割split()
arcII码为0x01,0x02作为分隔符 -
jj可爱熊:
希望楼主能多多赐教啊~~~
MyEclipse + AXIS2 -
jj可爱熊:
yumitcd 写道选择services.xm文件,这个xml ...
MyEclipse + AXIS2 -
jj可爱熊:
SayHelloTest.java中总是报错:org.exam ...
MyEclipse + AXIS2
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZZJGBH"', NULL ,NULL,NULL,0,0,45"
"64894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZRQBH"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'E4B883E6989FE8B7AFE"
"4B8ADE7A791E5AEBFE8888DE59FBAE5BBBAE5B7A52020'; SREC.MAXVAL := 'EE808BE888A"
"8E5AFAE3138E58FB7E4B98BE4BA8C'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.N"
"OVALS := DBMS_STATS.NUMARRAY(1187586097368370000000000000000000000,12383738"
"85440880000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SR"
"EC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZZQC"', NU"
"LL ,NULL,NULL,55480,.0000180245133381399,163043,srec,45,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XSH"', NULL ,NULL,NULL,0,0,45648"
"94,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZXBJ"', NULL ,NULL,NULL,0,0,4564"
"894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XQLFMC"', NULL ,NULL,NULL,0,0,45"
"64894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZRQMC"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XZZRQ"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"HJZRQ"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '30'; SREC.MAXVAL :="
" '30'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(249230249209672000000000000000000000,2492302492096720000000000000000000"
"00); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET"
"_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XXMJ"', NULL ,NULL,NULL,1,1,4106790,s"
"rec,2,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZFSJ"', NULL ,NULL,NULL,0,0,4564"
"894,srec,1,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D06040F262B'; SR"
"EC.MAXVAL := '786D060B053930'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2454987.60951389,2454994.20609954); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"T_BS_LK_GAZK"','"SXSJ"', NULL ,NULL,NULL,38,.0263157894736842,0,srec,8"
",6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D060A0E1418'; SR"
"EC.MAXVAL := '786D060B060702'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2454993.55512731,2454994.21251157); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"T_BS_LK_GAZK"','"RKSJ"', NULL ,NULL,NULL,25818,.0000387326671314587,0,"
"srec,8,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D060A0E1418'; SR"
"EC.MAXVAL := '786D060B060702'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2454993.55512731,2454994.21251157); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"T_BS_LK_GAZK"','"ZHGXSJ"', NULL ,NULL,NULL,25818,.0000387326671314587,"
"0,srec,8,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '30312D3131E69C882D3"
"038'; SREC.MAXVAL := '33312D38E69C88202D3038'; SREC.EAVS := 0; SREC.CHVALS "
":= NULL; SREC.NOVALS := DBMS_STATS.NUMARRAY(2502276677726560000000000000000"
"00000,265804560733121000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMA"
"RRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"'"
",'"YBZHSJC"', NULL ,NULL,NULL,325,.00307692307692308,4035034,srec,3,6); END"
";"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3230303036303039373"
"9'; SREC.MAXVAL := '32303036303035313537'; SREC.EAVS := 0; SREC.CHVALS := N"
"ULL; SREC.NOVALS := DBMS_STATS.NUMARRAY(26059221646030700000000000000000000"
"0,260592218309964000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY"
"(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"Y"
"BZJ"', NULL ,NULL,NULL,4563950,.000000219108447726202,0,srec,11,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
Import terminated successfully with warnings.
查了些资料,加了statistics=none
imp user/user file=file.dmp full=y ignore=y statistics=none
解决
参数说明
exp userid=user_name/user_pwd@net_service_name owner=user_name file=exp_user_name.dmp log=exp_user_name.log buffer=67108864 statistics=none grants=n consistent=y
buffer缓冲区大小,64M,再往上也没有明显的性能提升
statistics:表示不导出分析数据
grants:相关对象的授权
consistent:确保在imp的时候,不会出现fk不能enable的情况
exp help=y可以查看所有选项和说明,imp也一样
"ORA-01659: 无法分配超出 7 的 MINEXTENTS (在表空间 PERFSTAT 中)"
通过baidu,问题搞定,呵!baidu越来越强大了,解决方法如下:
第1步:修改datafile的autoextend
SQL> alter database datafile 'C:\ORACLE\ORADATA\SDBY\perfstat.dbf' autoextend on;
第2步:调用spdrop.sql删除之前create的对象
SQL> @?/rdbms/admin/spdrop.sql
第3步:重新调用spcreate.sql来创建对象
SQL> @?/rdbms/admin/spcreate.sql
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZZJGBH"', NULL ,NULL,NULL,0,0,45"
"64894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZRQBH"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'E4B883E6989FE8B7AFE"
"4B8ADE7A791E5AEBFE8888DE59FBAE5BBBAE5B7A52020'; SREC.MAXVAL := 'EE808BE888A"
"8E5AFAE3138E58FB7E4B98BE4BA8C'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.N"
"OVALS := DBMS_STATS.NUMARRAY(1187586097368370000000000000000000000,12383738"
"85440880000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SR"
"EC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZZQC"', NU"
"LL ,NULL,NULL,55480,.0000180245133381399,163043,srec,45,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XSH"', NULL ,NULL,NULL,0,0,45648"
"94,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZXBJ"', NULL ,NULL,NULL,0,0,4564"
"894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XQLFMC"', NULL ,NULL,NULL,0,0,45"
"64894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZRQMC"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XZZRQ"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"HJZRQ"', NULL ,NULL,NULL,0,0,456"
"4894,srec,0,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '30'; SREC.MAXVAL :="
" '30'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(249230249209672000000000000000000000,2492302492096720000000000000000000"
"00); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET"
"_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"XXMJ"', NULL ,NULL,NULL,1,1,4106790,s"
"rec,2,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"ZFSJ"', NULL ,NULL,NULL,0,0,4564"
"894,srec,1,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D06040F262B'; SR"
"EC.MAXVAL := '786D060B053930'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2454987.60951389,2454994.20609954); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"T_BS_LK_GAZK"','"SXSJ"', NULL ,NULL,NULL,38,.0263157894736842,0,srec,8"
",6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D060A0E1418'; SR"
"EC.MAXVAL := '786D060B060702'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2454993.55512731,2454994.21251157); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"T_BS_LK_GAZK"','"RKSJ"', NULL ,NULL,NULL,25818,.0000387326671314587,0,"
"srec,8,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D060A0E1418'; SR"
"EC.MAXVAL := '786D060B060702'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2454993.55512731,2454994.21251157); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"T_BS_LK_GAZK"','"ZHGXSJ"', NULL ,NULL,NULL,25818,.0000387326671314587,"
"0,srec,8,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '30312D3131E69C882D3"
"038'; SREC.MAXVAL := '33312D38E69C88202D3038'; SREC.EAVS := 0; SREC.CHVALS "
":= NULL; SREC.NOVALS := DBMS_STATS.NUMARRAY(2502276677726560000000000000000"
"00000,265804560733121000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMA"
"RRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"'"
",'"YBZHSJC"', NULL ,NULL,NULL,325,.00307692307692308,4035034,srec,3,6); END"
";"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3230303036303039373"
"9'; SREC.MAXVAL := '32303036303035313537'; SREC.EAVS := 0; SREC.CHVALS := N"
"ULL; SREC.NOVALS := DBMS_STATS.NUMARRAY(26059221646030700000000000000000000"
"0,260592218309964000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY"
"(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"T_BS_LK_GAZK"','"Y"
"BZJ"', NULL ,NULL,NULL,4563950,.000000219108447726202,0,srec,11,6); END;"
IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 4194
ORA-06512: at line 1
Import terminated successfully with warnings.
查了些资料,加了statistics=none
imp user/user file=file.dmp full=y ignore=y statistics=none
解决
参数说明
exp userid=user_name/user_pwd@net_service_name owner=user_name file=exp_user_name.dmp log=exp_user_name.log buffer=67108864 statistics=none grants=n consistent=y
buffer缓冲区大小,64M,再往上也没有明显的性能提升
statistics:表示不导出分析数据
grants:相关对象的授权
consistent:确保在imp的时候,不会出现fk不能enable的情况
exp help=y可以查看所有选项和说明,imp也一样
"ORA-01659: 无法分配超出 7 的 MINEXTENTS (在表空间 PERFSTAT 中)"
通过baidu,问题搞定,呵!baidu越来越强大了,解决方法如下:
第1步:修改datafile的autoextend
SQL> alter database datafile 'C:\ORACLE\ORADATA\SDBY\perfstat.dbf' autoextend on;
第2步:调用spdrop.sql删除之前create的对象
SQL> @?/rdbms/admin/spdrop.sql
第3步:重新调用spcreate.sql来创建对象
SQL> @?/rdbms/admin/spcreate.sql
发表评论
-
Myeclipse中安装mybatis generator插件
2018-03-14 11:35 8421、下载mybatis generator插件。 2、把 ... -
做exe服务
2018-03-14 11:34 439让程序作为服务运行 ... -
oracle 11g完美导出到oracle10g
2017-02-28 15:22 478oracle11g用exp命令导出的dmp文件10g是不能 ... -
多线程操作hashtable的问题
2017-02-10 11:29 1026大家都知道hashmap是线程不安全的,hashtable是 ... -
redis存储list
2017-02-06 15:01 493把List转换成JSON,存储到Redis,取出来的时候,再 ... -
ActiveMQ例子
2017-01-23 15:36 11391.下载ActiveMQ 去官方网站下载:http:// ... -
redis安装及示例
2017-01-23 14:43 7651.安装Redis 官方网站:http://redis. ... -
redis+spring例子
2017-01-22 17:44 633一、Redis了解 1.1、Redis ... -
Zookeeper的集群配置
2017-01-19 16:29 836一 集群的作用 为了获得可靠的 ZooKeeper 服务, ... -
实现只能一个用户登录
2017-01-19 16:21 686功能:当你在一台电脑上登录了账号,然后又在另外一台电脑上登录 ... -
论如何进行有效的需求管理
2012-06-10 19:51 848通过高级项目经理5天课 ... -
ORA-28000: the account is locked
2011-03-03 18:32 2633最近两个朋友问我同样的问题,他们发现数据库里面有一个账户总是莫 ... -
sql2005链接sql2000
2010-10-19 13:04 980服务器是sql server 2000的,客户端是2005的, ... -
虚拟机的IP地址为什么和本机不一样?
2010-05-13 16:46 6207最近在配置虚拟机,但发现虚拟机的ip地址和局域网内的其它非 ... -
sql面试题
2010-03-03 13:11 1371昨天去滨江的一个公司面试,遇到一个数据库的题目,总结下 ... -
an error occurred while completing process -java.lang.reflect.InvocationTargetEx
2010-01-29 17:09 1476在使用codegen插件来从WSDL文件生成代码时,到了最后一 ... -
MyEclipse + AXIS2
2010-01-29 17:03 6863一、环境准备 1.1软件下载准备 Tomcat 5.5下载地 ... -
Spring学习笔记:第二章 Spring中IoC的入门实例
2010-01-28 15:14 879第二章 Spring中IoC的入门实例 Spring的模 ... -
Spring学习笔记:1、概念理解
2010-01-28 15:13 815转载自:http://dev.csdn.net/author/ ... -
微软自带jdbc驱动缺陷
2009-07-02 14:15 1134微软自带的3个驱动包分 ...
相关推荐
oracle跨版本导入备份DMP报实际值最大值错误
1. Oracle逻辑错误造成无法启动 .................. 2. 某一个datafile故障或丢失 .................. 3. 某一个tablespace故障 .................. 4. 意外drop table .................. 5. 意外drop user ...
如果不采用Archive Log模式运行Oracle数据库,只有两种可用的备份方法:冷备份或export逻辑备份。根据关键业务服务器的特点,停下数据库进行冷备份是根本不可能的,因此如果不采用Archive Log,只能进行逻辑备份。 ...
1、在进行导入恢复时,如果是全部导入的话,就需要将原有的用户删除,这样此用户所拥有的数据就可以直接被删除了,否则在进导入时会下面的错误提示( ORACLE error 2291 encountered )那是因为与原有一些表,或...
当初使用PL/SQL是可以的,后来在因为工作需要,在一次导入同事发来的一份Oracle数据库备份,在命令符下使 用IMP 语句进行导入出现 6550错误,经上网查原因有是因为服务端与客户端使用的版本不匹配的一种说法。于是 ...
3.1.12 检查导出/导入错误 3.1.13 用导出和导入管理区 3.1.14 组织和命名导出/导入文件 3.1.15 显示导出文件的内容 3.1.16 不能对恢复同时使用导出和归档 重做日志 3.1.17 增量、累积和完全的导出和导入 3.2 ...
Oracle11G数据库的的exp和imp工具,数据库在做备份时若出现导出导入文件错误,一般是缺少exp.exe 和imp.exe工具或者该工具出行问题所致。使用方法:解压后将文件放到X:\development\Oracle\product\11.2.0\dbhome_1...
20由于EXP不向上兼容,语言不兼容,导致不同版本、不同字符集的数据库无法导入 21 由于创建表空间时误将其创建在以‘本地管理’,导致在表空间上的所有对象无法修改其存储参数 22 错误地在系统表空间上建无关的数据...
12.7.2导入导出工具数据泵 12.7.3跨平台数据迁移 12.7.4可传输表空间 12.7.5使用RMAN工具复制数据库 12.8本章小结 第13章 RAC恢复 13.1恢复技术基础 13.1.1恢复解决方案 13.1.2 SCN时间机制 13.1.3日志线程...
oracle10g导入11g导出数据时报版本号错误,如果直接用UE修改,又是数据较大且不能保证修改成功,网上搜集到神器,可以快捷修改dmp版本号:各版本对应版本号: 11g R2:V11.02.00 11g R1:V11.01.00 10g:V10.02.01 ...
实验38:在块中处理错误exception 78 编写程序 80 实验39:触发器 80 实验40:编写函数 82 实验41:编写存储过程 83 实验42:编写包package 85 第三部分数据库的体系结构 88 实例的维护 88 实验43:数据库的最高帐号...
我们常会遇到这样的问题,客户系统发现异常或问题,给我们...报错的原因是客户使用的高版本的数据库,导出的DMP在低版本数据库导入时则会报版本错误,无法完成导入。如11g的备份文件,无法在10g的数据库上直接恢复。
8.7.1 与撤销相关的错误条件 294 8.7.2 用于撤销管理与保留保证的参数 294 8.7.3 调整与监视撤销表空间 295 8.7.4 创建和管理撤销表空间 297 8.8 本章知识点回顾 297 8.9 自测题 299 8.10 自测题答案 301 第...
导入/导出是ORACLE幸存的最古老的两个命令行工具,其实我从来不认为Exp/Imp是一种好的备份方式,正确的说法是Exp/Imp只能是一个好的转储工具,特别是在小型数据库的转储,表空间的迁移,表的抽取,检测逻辑和物理...
如果能把笔记里的例子都敲一遍,保证你学会Oracle,涉及系统结构、安全、查询、锁、表分区、数据库对象、PL/SQL语法、游标、子程序、程序包、触发器、内置程序包、备份与恢复、导入导出、ORA错误等各个领域
EXP_FULL_DATABASE, IMP_FULL_DATABASE这两个角色用于数据导入导出工具的使用。 自定义角色 Oracle建议我们自定义自己的角色,使我们更加灵活方便去管理用户 创建角色 SQL> create role admin; 授权给...