Export/impor Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Export/impor Error

  1. #1
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56

    Export/impor Error

    Let me explain:

    I've exported an user and wanna import in another DB. Both oracle 8.1.7 When doing that, the following message appears:

    [Importação realizada nos conjuntos de caracteres WE8MSWIN1252 e NCHAR AL16UTF16
    o cliente de exportação usa o conjunto de caracteres WE8ISO8859P1 (conversão de charset possível)
    o servidor de exportação usa o conjunto de caracteres NCHAR WE8ISO8859P1 (conversão de ncharset possível)
    . importando objetos de ADAMI para ADAMI
    . . importando table "PECAS" 15 linhas importadas
    IMP-00017: a instrução a seguir falhou com o erro 6550 ORACLE:
    "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3031'; SREC.MAXVAL "
    ":= '52463233'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STA"
    "TS.NUMARRAY(250224087280251000000000000000000000,42719208826397300000000000"
    "0000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_S"
    "TATS.SET_COLUMN_STATS(NULL,'"PECAS"','"COD_PECA"', NULL ,NULL,NULL,15,,0666"
    "666666666667,0,srec,7,2); END;"
    IMP-00003: Erro Oracle: 6550 encontrado
    ORA-06550: linha 1, coluna 371:
    PLS-00103: Encontrado o símbolo "," quando um dos seguintes símbolos era esperado:( - + case mod not null others avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe
    O símbolo "null" foi substituído por "," para continuar.


    Can someone help me to avoid it??

    I really thanks!!!
    Adilsom José Musskopf
    Live like each of your days was the last.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    The problem is a known bug (1335408) it's fixed in 8.1.7.3 and 9i

    You can get round it by specifing ANALYZE=N or RECALCULATE_STATISTICS=Y on import command line so that the statistics are not imported

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56
    It really works good!!

    Thanks a lot!!!!
    Adilsom José Musskopf
    Live like each of your days was the last.

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