DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: IMP-00017

  1. #1
    Join Date
    Mar 2002
    Posts
    10

    Arrow

    I have a problem:
    i did an export of a 8.0.6 database and import into 8.1.7.
    In some tables show this error:
    IMP-00017: following statement failed with ORACLE error 6550:
    "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '414257'; SREC.MAXVA"
    "L := '657370'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STA"
    "TS.NUMARRAY(338844827688744000000000000000000000,52676333337063900000000000"
    "0000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_S"
    "TATS.SET_COLUMN_STATS(NULL,'"PAISES"','"PAIS_COD"', NULL ,NULL,NULL,254,,00"
    "393700787401575,0,srec,4,2); END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 1, column 373:
    PLS-00103: Encountered the symbol "," when expecting one of the following:

    ( - + mod not null others
    avg
    count current exists max min prior sql stddev sum variance
    execute forall time timestamp interval date


    The symbol "null" was substituted for "," to continue.


    Someone can help me, please.
    Thank very much.

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    from ur output i guess ur missing one null.Can u see three null and after that 254 then there is no value but a comma is present i guess this must be causing the problem.

    cheese
    anandkl
    anandkl

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