Re: error during import

mkuruvil2000_at_yahoo.com (Jay) wrote in message news:<66518e50.0204081333.7da5283b_at_posting.google.com>...
> When I import the data from one of our servers to our backup server, I
> get the following error. Could someone please look at the error and
> tell me if this is something I need to worry about, and how I could
> correct this problem.

Jay,

The problem is in the SET_COLUMN_STATS parameters (extra comma). I'm not sure how this error was created. I assume your backup and production server are at the same Oracle version. You should consider manually entering the column statistics with the following corrected command:

DECLARE
  SREC DBMS_STATS.STATREC;
BEGIN

  SREC.MINVAL := '444A532D32303031303531102D30303534'; 
  SREC.MAXVAL := '444A532D32303031303531302D37363433'; 
  SREC.EAVS   := 0; 
  SREC.CHVALS := NULL; 
  SREC.NOVALS := DBMS_STATS.NUMARRAY
  	(354583753804100000000000000000000000,
  	 354583753804100000000000000000000000);

                              '"ADGSTR"',
                              '"CLNTACCNBR"',
                              NULL,
                              NULL,
                              NULL,
                              27,
                              037037037037037,
                              0,
                              srec,
                              17,
                              0); 

Regards,
Paul Walker Received on Tue Apr 09 2002 - 17:33:12 CEST