Oracle Error 20001 Encountered
import -URGENT If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Thread: Getting error during import -URGENT Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… http://dbaforums.org/oracle/index.php?showtopic=10067 Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-14-2001,09:00 PM #1 rafiq View Profile View Forum Posts Junior Member Join Date Feb 2001 Posts 27 Hi there, I have a database of version 8.1.5 on unix sun-solaris(5.8). I've upgrdaed this from 8.0.6 couple of days ago. After upgrading, I export the database and import it to another http://www.dbasupport.com/forums/showthread.php?6860-Getting-error-during-import-URGENT database of 8.1.5 as before. After upgradation, export is fine. when I import to another database, it imports all the rows, indexes etc. but i'm getting the following error: . . importing table "TEMP_MULTI_4A" 85948 rows imported IMP-00017: following statement failed with ORACLE error 20001: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :=" " NULL; SREC.NOVALS := DBMS_STATS.NUMARRAY(202371,2973729); SREC.BKVALS := D" "BMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'T" "EMP_MULTI_4A','SHRFNBR',NULL,NULL,NULL,84919,.0000117759276487005,0,srec,-4" "325375,0); END;" IMP-00003: ORACLE error 20001 encountered ORA-20001: Invalid or inconsistent input values ORA-06512: at "SYS.DBMS_STATS", line 1669 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.NOVALS := DBMS_STATS.NUMARRAY(1,4); SREC.BKVALS := DBMS_STATS.N" "UMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'TEMP_MULTI_4" "A','OCOUNT',NULL,NULL,NULL,4,.25,0,srec,-4325375,0); END;" IMP-00003: ORACLE error 20001 encountered ORA-20001: Invalid or inconsistent input values ORA-06512: at "SYS.DBMS_STATS", line 1669 ORA-06512: at line 1 Anybody has any idea - please it's urgent. Thanks babu Reply With Quote 02-14-2001,09:04 PM #2 sreddy View Profile View Forum Posts Senior Advisor Join Date Feb 2000 Location Washington DC Posts 1,843 After import did you comp
following statement failed with ORACLE error 20001: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :=" " NULL; http://lshh83.iteye.com/blog/699940 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: http://stackoverflow.com/questions/61963/howto-import-an-oracle-dump-in-an-different-tablespace 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 oracle error 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 oracle error 20001 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:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Howto import an oracle dump in an different tablespace up vote 29 down vote favorite 13 I want to import an oracle dump into a different tablespace. I have a tablespace A used by User A. I've revoked DBA on this user and given him the grants connect and resource. Then I've dumped everything with the command exp a/*** owner=a file=oracledump.dmp log=log.log compress=y Now I want to import the dump into the tablespace B used by User B. So I've given him the grants on connect and resource (no DBA). Then I've executed the following import: imp b/*** file=oracledump.dmp log=import.log fromuser=a touser=b The result is a log with lots of errors: IMP-00017: following statement failed with ORACLE error 20001: "BEGIN DBMS_STATS.SET_TABLE_STATS IMP-00003: ORACLE error 20001 encountered ORA-20001: Invalid or inconsistent input values After that I've tried the same import command but with the option statistics=none. This resulted in the following errors: ORA-00959: tablespace 'A_TBLSPACE' does not exist How should this be done? Note: a lot of columns are of type CLOB. It looks like the problems have something to do with that. Note2: The oracle versions are a mixture of 9.2, 10.1 and 10.1 XE. But I don't think it has to do with versions. oracle share|improve this question edited Sep 15 '08 at 13:54 asked Sep 15 '08 at 7:15 Michiel Overeem 2,21721624 add a comment| 9 Answers 9 active oldest votes up vote 25 down vote accepted You've got a couple of issues here. Firstly, the different versions of Oracle you're using is the reason for the table statistics error - I had the same issue when some of our Oracle 10g Databases got upgraded to Release 2, and some were still on Release 1 and I was swapping .DMP files between them. The solution that