Oracle Error 20001 Import
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle Import Error Want to Advertise Here? Solved Oracle Import Error Posted on 2009-05-15 Oracle Database Databases 1 Verified http://dbaforums.org/oracle/index.php?showtopic=10067 Solution 1 Comment 3,116 Views Last Modified: 2013-12-19 Our data services department are getting errors when they try to import a particular database. The error they are get is (See code scetion) and it just goes on and on an don... and ends with: IMP-00003: ORACLE error 603 encountered ORA-00603: ORACLE server session terminated by fatal error IMP-00017: following https://www.experts-exchange.com/questions/24412214/Oracle-Import-Error.html statement failed with ORACLE error 3114: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PC_CUSSN"',NULL,NULL,NULL,580414,2" Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Export file created by EXPORT:V09.02.00 via conventional path Warning: the objects were exported by SYSTEM, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses UTF8 character set (possible charset conversion) . importing POWER_PARK's objects into POWER_PARK . . importing table "CREATE$JAVA$LOB$TABLE" 1 rows imported IMP-00017: following statement failed with ORACLE error 20001: "BEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"CREATE$JAVA$LOB$TABLE"',NULL,NULL," "NULL,1,5,25,6); END;" IMP-00003: ORACLE error 20001 encountered ORA-20001: Invalid or inconsistent input values ORA-06512: at "SYS.DBMS_STATS", line 3981 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 20001: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4C4F41444A4156412F4" "C4F422F4B4559'; SREC.MAXVAL := '4C4F41444A4156412F4C4F422F4B4559'; SREC.EAV" "S := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMARRAY(39622204257" "2649000000000000000000000,396222042572649000000000000000000000); SREC.BKVAL" »Databases »At import errors by call DBMS_STATS.SET_INDEX_STATS. As it to treat Pages 1 http://www.progtown.com/topic545892-at-import-errors-by-call-dbmsstatssetindexstats-as-it-to-treat.html You must login or register to post a reply Topic RSS feed Posts [ 4 ] 1 Topic by DVE 2012-05-05 19:28:49 DVE Member Offline Registered: 2002-05-02 Posts: 3,454 Topic: At import errors by call DBMS_STATS.SET_INDEX_STATS. As it to treat How it to treat?IMP-00017: at performance of following command ORACLE oracle error returns an error 20001: "BEGIN DBMS_STATS.SET_INDEX_STATS (NULL, '" ACCOUNT_SERVICE_ACC_FD_TD_CALC "', N" "ULL,NULL,NULL,275337,3499,176207,1,1,52849,2,6); END;" IMP-00003: ORACLE produced an error 20001 ORA-20001: Invalid or inconsistent input values ORA-06512: on "SYS.DBMS_STATS", line 3725 ORA-06512: on line 1 IMP-00017: at performance of following command ORACLE returns an error 20001: "BEGIN DBMS_STATS.SET_TABLE_STATS (NULL, '" ACCOUNT_SERVICE "', oracle error 20001 NULL, NULL, NULL, 2" "75171,2196,54,6); END;" IMP-00003: ORACLE produced an error 20001 ORA-20001: Invalid or inconsistent input values ORA-06512: on "SYS.DBMS_STATS", line 3981 ORA-06512: on line 1 IMP-00017: at performance of following command ORACLE returns an error 20001: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL: = ' C21E33 '; SREC.MAXVA" "L: = ' C31D3C4A '; SREC.EAVS: = 0; SREC.CHVALS: = NULL; SREC.NOVALS: = DBMS_S" "TATS.NUMARRAY (2950,285973); SREC.BKVALS: = DBMS_STATS.NUMARRAY (0,1); SREC.E" "PC: = 2; DBMS_STATS.SET_COLUMN_STATS (NULL, '" ACCOUNT_SERVICE "', '" N "', NULL," "NULL,NULL,275087,.0000036352135869743,0,srec,5,6); END;" IMP-00003: ORACLE produced an error 20001 ORA-20001: Invalid or inconsistent input values ORA-06512: on "SYS.DBMS_STATS", line 3425 ORA-06512: on line 1 IMP-00017: at performance of following command ORACLE returns an error 20001: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL: = ' C109 '; SREC.MAXVAL" ": = ' C20E4D '; SREC.EAVS: = 0; SREC.CHVALS: = NULL; SREC.NOVALS: = DBMS_STATS" ".NUMARRAY (8,11,12,13,15,16,19,20,22,23,25,27,30,31,33,34,35,36,40,41,42,43," "44,45,49,55,56,57,58,60,62,64,66,69,70,71,73,75,77,78,79,80,81,82,84,86,87," "88,90,93,94,98,100,101,122,558,561,581,684,813,904,1376); SREC.BKVALS: = DB" "MS_STATS.NUMARRAY (495,511,512,525,527,543,546,548,550,559,572,695,792,826,8" "27,839,1246,1249,1260,1979,