Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When Performing A Database Import On 8.1.7.4 I Get Ora-6550

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

From: Steve <ThisOne_at_Aint.valid>
Date: Thu, 22 Jul 2004 20:27:57 +1200
Message-ID: <cdntqd$apm$1@lust.ihug.co.nz>


Iain Heath wrote:
> 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:

... isn't the first question 'do I really need to import the old dbms stats'?

I'd see if I can get the production data imported first, then install the stats from new. ISTR it was a pretty new package around 8.1.6 time, and underwent a lot of upgrades.

$0.02

Steve Received on Thu Jul 22 2004 - 03:27:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US