Tuesday, August 26, 2014

I was importing an Oracle11g into Oracle12c. I had created some of the tables in advance to remove partitioning and the import log gave me the following error:


IMP-00003: ORACLE error 20000 encountered
ORA-20000: BSG_VC_RECENT invalid partition name
ORA-06512: at "SYS.DBMS_STATS", line 7840
ORA-06512: at "SYS.DBMS_STATS", line 13507
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20000:
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E'; SREC.MAXVAL :="
 " '4E'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
 "RAY(404999154965717000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARR"
 "AY(25418); SREC.EPC := 1; DBMS_STATS.SET_COLUMN_STATS(NULL,'"BSG_RECENT"','""
 "EXCLUDE"','"BSG_VC_RECENT"',NULL,NULL,1,.00000491777480525612,0,srec,2,6); "

 "END;"


To solve this problem I added statistics=none to the command line when importing.