-
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Hi,
The errors are due to the Unpublished Bug:3341396 : Abstract: ORA-6553: PLS-123: PROGRAM TOO LARGE
workaround:
Try statistics=none
-
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
Last edited by gopu_g; 04-17-2008 at 01:31 AM.
-
hi gopu_g,
pls verify metalink for the bug i have specified.
-
Originally Posted by ams-jamali
hi gopu_g,
pls verify metalink for the bug i have specified.
thanks jamali, i will check it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|