Solved

Oracle Import Error

Posted on 2009-05-15
1
3,163 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
ID: 24397256
try with
imp user/password FILE=... STATISTICS=recalculate ....
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

867 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

24 Experts available now in Live!

Get 1:1 Help Now