trying to move a database from UNIX(AIX) to W2K
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: trying to move a database from UNIX(AIX) to W2K

Hybrid View

  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Angry

    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


  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    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.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width