Re: Big problem with IMP (Error 6550)

AFAIK this is bug number 1335408. The patch set is 8.1.7.3

According to Metalink the workaround is:

   use the option ANALYZE = N
   -or-
   use the option RECALCULATE_STATISTICS = Y

hth
Anthony Hogan
ahogan-nospam-_at_iespana.es

Epicentre Team A ANNECY wrote:
>
> Hi
> I can't import dump. i've the error:
>
> IMP-00017: Echec de l'instruction suivante avec erreur ORACLE 6550 :
> "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3031303030';
> SREC.M"
> "AXVAL := '3935383830'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS :=
> "
>
> "DBMS_STATS.NUMARRAY(250227905145360000000000000000000000,297040342811769000
> "
> "000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC :=
> 2"
> ";
> DBMS_STATS.SET_COLUMN_STATS(NULL,'"EPI_CODES_POSTAUX"','"EPI_CODE_POSTAL_"
> "ID"', NULL ,NULL,NULL,6099,,000163961305131989,0,srec,5,0); END;"
> IMP-00003: Erreur ORACLE 6550 rencontrée
> ORA-06550: Ligne 1, colonne 403 :
> PLS-00103: Symbole "," rencontré à la place d'un des symboles suivants :
>
> ( - + 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>
> Symbole "null" a été substitué à "," pour continuer.
>
> Have you a solution ?
> Why during Import there is reference to DBMS_STAT ?
>
> Bests regards
> Denis
>
> --
> ----------------------------------------------------------------------------
> ------------------------------
> Très cordialement
> Denis Jeanneret - Directeur Technique, Division ORACLE
> Epicentre - 529 Route des Vernes 74370 PRINGY
> Tel: 04.5009.7000
> Fax:04.50.66.92.19
> web: www.epicentre.fr
> ----------------------------------------------------------------------------
> ------------------------------
Received on Mon May 27 2002 - 11:57:55 CDT