Do you have any tables with a default value of -1?

I've seen where a table is modified after the initial database was
created, and then the import/export failed due to this constraint.

On my database, it was only one table; I was able to remove the
constraint in OEM, apply, and then export (which always worked) and then
get a successful import.

Take a look.

Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]

-----Original Message-----
From: Purusottam Kaushik
[mailto:oracledba-ezmlmshield-x22608163.[Email address protected]
Sent: Tuesday, May 29, 2007 2:01 PM
To: LazyDBA Discussion
Subject: Import/Export error



Hi ALL ORACLE GURUS



We have a production database running on Oracle 10G and R2.

I have an export copy of the production database and now I want to
import
the same on my local database oracle 10 G R2.

But log file displays me following errors.



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 :=
'786604160C3B0E';
SR"

"EC.MAXVAL := '786604160C3B0E'; SREC.EAVS := 0; SREC.CHVALS := NULL;
SREC.NO"

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

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

"LL,'"ACCOUNT_CODE_CATEGORIES"','"DATE_CREATED"', NULL
,NULL,NULL,1,1,0,srec"

",8,6); END;"



There are number of such errors in the log files.



Any help will be highly appreciated.



Thanks In Advance.





Thanks

Purusottam Kaushik





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page