Solved

Oracle Import Error

Posted on 2009-05-15
1
3,134 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 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"

 "S := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(N"

 "ULL,'"CREATE$JAVA$LOB$TABLE"','"NAME"', NULL ,NULL,NULL,1,1,0,srec,17,6); E"

 "ND;"

IMP-00003: ORACLE error 20001 encountered

ORA-20001: Invalid or inconsistent input values

ORA-06512: at "SYS.DBMS_STATS", line 3425

ORA-06512: at line 1

IMP-00017: following statement failed with ORACLE error 20001:

 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786C031A170334'; SR"

 "EC.MAXVAL := '786C031A170334'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"

 "VALS := DBMS_STATS.NUMARRAY(2454552.91864583,2454552.91864583); SREC.BKVALS"

 " := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"

 "LL,'"CREATE$JAVA$LOB$TABLE"','"LOADTIME"', NULL ,NULL,NULL,1,1,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 3425

ORA-06512: at line 1

. . importing table                "FACCOUNTTRANS"    4980770 rows imported

IMP-00017: following statement failed with ORACLE error 1917:

 "GRANT SELECT ON "FACCOUNTTRANS" TO "ASUDSTAGE""

IMP-00003: ORACLE error 1917 encountered

ORA-01917: user or role 'ASUDSTAGE' does not exist

IMP-00017: following statement failed with ORACLE error 20001:

 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"AT_ID"',NULL,NULL,NULL,4975331,147"

 "84,4975331,1,1,739075,2,6); END;"

IMP-00003: ORACLE error 20001 encountered

ORA-20001: Invalid or inconsistent input values

ORA-06512: at "SYS.DBMS_STATS", line 3725

ORA-06512: at line 1

IMP-00017: following statement failed with ORACLE error 20001:

 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"AT_RSN"',NULL,NULL,NULL,4975331,13"

 "550,4975331,1,1,739112,2,6); END;"

IMP-00003: ORACLE error 20001 encountered

ORA-20001: Invalid or inconsistent input values

ORA-06512: at "SYS.DBMS_STATS", line 3725

ORA-06512: at line 1

IMP-00017: following statement failed with ORACLE error 20001:

 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"AT_INVOICE_ID"',NULL,NULL,NULL,497"

 "5331,17496,1290004,1,2,2903650,2,6); END;"

IMP-00003: ORACLE error 20001 encountered

ORA-20001: Invalid or inconsistent input values

ORA-06512: at "SYS.DBMS_STATS", line 3725

ORA-06512: at line 1

IMP-00017: following statement failed with ORACLE error 20001:

 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"AT_TYPE_INVOICE"',NULL,NULL,NULL,4"

 "975331,26658,4465151,1,1,2430860,2,6); END;"

IMP-00003: ORACLE error 20001 encountered

ORA-20001: Invalid or inconsistent input values

ORA-06512: at "SYS.DBMS_STATS", line 3725

ORA-06512: at line 1

IMP-00017: following statement failed with ORACLE error 20001:

 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"AT_DATE"',NULL,NULL,NULL,4975331,2"

 "0630,266880,1,1,208598,2,6); END;"

Open in new window

0
Comment
Question by:ncartwrightt2systems
1 Comment
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 500 total points
Comment Utility
try with
imp user/password FILE=... STATISTICS=recalculate ....
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now