Someone else has answered the specific problem, but as to your question why
Import should be referencing DBMS_STATS.... because import calculates
statistics as part of the import process (unless you tell it not to).
Regards
HJR
"Epicentre Team A ANNECY" <djeanneret_at_epicentre.fr> wrote in message
news:actbjg$9gl$1_at_wanadoo.fr...
> 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 - 18:56:32 CDT
