Import Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Import Problem

  1. #1
    Join Date
    Apr 2008
    Posts
    1

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Jan 2007
    Posts
    231
    Hi,

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

    workaround:

    Try statistics=none

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    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
    Last edited by gopu_g; 04-17-2008 at 01:31 AM.

  5. #5
    Join Date
    Jan 2007
    Posts
    231
    hi gopu_g,

    pls verify metalink for the bug i have specified.

  6. #6
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Quote 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
  •  



Click Here to Expand Forum to Full Width