-
Hi,
I'm trying to import a dump of an oracle database exported from a 8.1.7 running on AIX into an oracle of the same version running on a W2K server.
I got the following error in the log:
Verbunden mit: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
<
Export-Datei wurde von EXPORT:V08.01.07 über konventionellen Pfad erstellt
Importvorgang mit Zeichensatz WE8ISO8859P1 und Zeichensatz WE8ISO8859P1 NCHAR durchgeführt
. Import ARADMIN's Objekte in ARADMIN
IMP-00017: Nachfolgende Anweisung war wegen Oracle-Fehler 6550 erfolglos:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41524469616C6F673A4"
"4696172795570646174652D436C6F7365'; SREC.MAXVAL := '534C4146423A4642442D557"
"06461746542756666657238'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS "
":= DBMS_STATS.NUMARRAY(339167873521018000000000000000000000,432507273962847"
"000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC :"
"= 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"ACTLINK"','"NAME"', NULL ,NULL,NULL"
",4230,,000236406619385343,0,srec,24,0); END;"
IMP-00003: Oracle-Fehler 6550 gefunden
ORA-06550: Zeile 1, Spalte 457:
PLS-00103: Fand das Symbol "," als eines der folgenden erwartet wurde:
( - + mod not null others
avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
Das Symbol "null" ersetzte ",", um fortzufahren.
IMP-00017: Nachfolgende Anweisung war wegen Oracle-Fehler 6550 erfolglos:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL "
":= 'C22B50'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS"
".NUMARRAY(1,4279); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; "
"DBMS_STATS.SET_COLUMN_STATS(NULL,'"ACTLINK"','"ACTLINKID"', NULL ,NULL,NULL"
",4230,,000236406619385343,0,srec,3,0); END;"
IMP-00003: Oracle-Fehler 6550 gefunden
ORA-06550: Zeile 1, Spalte 307:
PLS-00103: Fand das Symbol "," als eines der folgenden erwartet wurde:
( - + mod not null others
avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
Das Symbol "null" ersetzte ",", um fortzufahren.
At first we thought it was an NLS_LANG problem but changing NLS_LANG environment variables on both macines to the same value didn't help either.
The parfile used to import was the following:
FILE=D:\download\kisra103-exp\ars.dmp
LOG=D:\download\kisra103-exp\import-ars.log
SHOW=N
IGNORE=N
GRANTS=Y
FULL=Y
DESTROY=Y
ROWS=N
Thanks for your help, Ralph Niere
-
How did you move the export file?
Across OS's I usually use FTP in binary mode, but an ASCII unlabeled tape is also a possibility (if available to you since you are obviously working in German and may not have American SCII available.)
If binary mode or it's equivalent is not used, the contents of the file can be 'trashed' in that high order bits are flipped to 0.