Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> When Performing A Database Import On 8.1.7.4 I Get Ora-6550
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_STATIMP-00017: following statement failed with ORACLE error 6550:
IMP-00003: ORACLE error 6550 encountered ORA-06550: line 1, column 479: PLS-00103: Encountered the symbol "," when expecting one of thefollowing:
( - + 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 thefollowing:
( - + 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 thefollowing: Received on Thu Jul 22 2004 - 03:14:31 CDT