Import Problem

Dear all,
I am using Oracle 9i production server supported for Baan Application. while importing it is throwing into the following error.

IMP-00003: ORACLE error 6540 encountered
ORA-06540: PL/SQL: compilation error
ORA-06553: PLS-123: program too large
IMP-00017: following statement failed with ORACLE error 6540:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(0,0); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"TTCEDI711400"','"T$LDAC"', NULL ,NULL,NULL,0,0,0,"
"srec,0,2); END;"

during the process, more trace files is also generating. then the process hangs, no improvements in import.

please help me out. it is urgent

thanks
dhaya

What your trace files are telling you?
How do you know process is hanging as opposed to being building indexes or validating constraints?

Hi,

The errors are due to the Unpublished Bug:3341396 : Abstract: ORA-6553: PLS-123: PROGRAM TOO LARGE

workaround:

Try statistics=none

Quote:

---

Originally Posted by ams-jamali

Hi,

The errors are due to the Unpublished Bug:3341396 : Abstract: ORA-6553: PLS-123: PROGRAM TOO LARGE

workaround:

Try statistics=none

---

you can Try the import with STATISTICS=none, seems that your import is failling at constructing some DBMS_STATS invocation.

as PAVB said

Did you check why traces file content ?
check also your alertlog file

hi gopu_g,

pls verify metalink for the bug i have specified.

Quote:

---

Originally Posted by ams-jamali

hi gopu_g,

pls verify metalink for the bug i have specified.

---

thanks jamali, i will check it :)