Problem in Import [message #244392] |
Tue, 12 June 2007 10:32 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
Hello,
i have dump file from previous oracle versions not sure
while importing it into 10.2.0.3.0 on os solaris 10 64 bit it thrwoing this error
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '20'; SREC.MAXVAL :="
" '57494C54454C'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_S"
"TATS.NUMARRAY(166153499473115000000000000000000000,453216490014463000000000"
"000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS"
"_STATS.SET_COLUMN_STATS(NULL,'"FIBRTKTARCH"','"KEYWORD"','"Q1_2004"',NULL,N"
"ULL,44,.0227272727272727,652732,srec,1,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: Q1_2004 invalid partition name
ORA-06512: at "SYS.DBMS_STATS", line 1675
ORA-06512: at "SYS.DBMS_STATS", line 4932
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20000:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '20'; SREC.MAXVAL :="
" '504D'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUM"
"ARRAY(166153499473115000000000000000000000,41694549422226700000000000000000"
"0000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.S"
"ET_COLUMN_STATS(NULL,'"FIBRTKTARCH"','"TKTRESOURCE"','"Q1_2004"',NULL,NULL,"
"7,.142857142857143,496366,srec,1,0); END;"
any one have ides why?
Thanks.
[Updated on: Tue, 12 June 2007 10:33] Report message to a moderator
|
|
|
|
|
|