When Performing A Database Import On 8.1.7.4 I Get Ora-6550

From: Iain Heath <iain.heath_at_uk.delarue.com>
Date: 22 Jul 2004 01:14:31 -0700
Message-ID: <b0647420.0407220014.73428c80@posting.google.com>

Hi I am importing a 8.1.6 dump file into a 8.1.7.4 database, I have created the users, assigned them there tablespaces etc and created a huge rollback seg.

When i start importing I get the following message below, Oracle informed me it was a bug at 8.1.6 and should not be effected in a 8.1.7.4 database.

Have tried several things, my last thing to try will be upgrade the 8.1.6 db to 8.1.7.4 and export and import again into my new database.

Anyones ideas are very much appricated!

Iain

Connected to: Oracle8i Release 8.1.7.4.1 - Production JServer Release 8.1.7.4.1 - Production

Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

. importing ITEMS's objects into ITEMS
. importing SYSTEM's objects into SYSTEM
. importing ITEMS's objects into ITEMS
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing OUTLN's objects into OUTLN
. importing ITEMS_STAT's objects into ITEMS_STAT

IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL :=
'323030342D30322D313"
"85F30393A30333A30335F30303030383635393738'; SREC.MAXVAL :=
'323030342D30332"
"D31335F30393A30303A35335F30303030333531373336'; SREC.EAVS := 0;
SREC.CHVALS"
" := NULL; SREC.NOVALS :=

DBMS_STATS.NUMARRAY(260592217687367000000000000000"
"000000,260592217687367000000000000000000000); SREC.BKVALS :=
DBMS_STATS.NUM"
"ARRAY(0,1); SREC.EPC := 2;

DBMS_STATS.SET_COLUMN_STATS(NULL,'ANOMALYOBJECT'"
",'LINK',NULL,NULL,NULL,1215,,000823045267489712,0,srec,30,0); END;"

IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 479:
PLS-00103: Encountered the symbol "," when expecting one of the

following:

   ( - + mod not null others <an identifier>    <a double-quoted delimited-identifier> <a bind variable> avg    count current exists max min prior sql stddev sum variance    execute forall time timestamp interval date    <a string literal with character set specification>    <a number> <a single-quoted SQL string> The symbol "null" was substituted for "," to continue. IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL :=
'786802120A0404'; SR"
"EC.MAXVAL := '7868030D0A0136'; SREC.EAVS := 0; SREC.CHVALS := NULL;
SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2453054,37711806,2453078,37561343);
SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'ANOMALYOBJECT','CREATION',NULL,NULL,NULL,1132,,00088339222614841,0,srec"
",7,0); END;"

IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 351:
PLS-00103: Encountered the symbol "," when expecting one of the

following:

   ( - + mod not null others <an identifier>    <a double-quoted delimited-identifier> <a bind variable> avg    count current exists max min prior sql stddev sum variance    execute forall time timestamp interval date    <a string literal with character set specification>    <a number> <a single-quoted SQL string> The symbol "null" was substituted for "," to continue. IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL :=
'786802120A0404'; SR"
"EC.MAXVAL := '7868030D0A0136'; SREC.EAVS := 0; SREC.CHVALS := NULL;
SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2453054,37711806,2453078,37561343);
SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'ANOMALYOBJECT','LASTUPDATE',NULL,NULL,NULL,1132,,00088339222614841,0,sr"
"ec,7,0); END;"

IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 353:
PLS-00103: Encountered the symbol "," when expecting one of the

following: Received on Thu Jul 22 2004 - 03:14:31 CDT