Page 1 of 2 12 LastLast
Results 1 to 15 of 18

Thread: import problem

  1. #1
    Join Date
    Apr 2008
    Posts
    9

    Unanswered: 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
    Last edited by dhayanithy; 04-16-08 at 04:13.

  2. #2
    Join Date
    Apr 2008
    Posts
    28
    Hi,

    I've done thousands of imports for BaaN DB on 9i , and I've never seen something like that...

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

    Usually for BaaN you only need to import tables, do you have any SP developed in-house?

    Regards
    Ignacio

    http://oracledisect.blogspot.com

  3. #3
    Join Date
    Apr 2008
    Posts
    9
    Hi ignacio,

    some Customisation has made inhouse. all others from vendor side.
    i will try with statistics=none parameter.
    keep scribbling

    thanks
    dhaya

  4. #4
    Join Date
    Apr 2008
    Posts
    8
    What your trace files are telling you?
    How do you know process is hanging as opposed to being building indexes or validating constraints?

  5. #5
    Join Date
    Apr 2008
    Posts
    9
    Quote Originally Posted by gopu_g
    What your trace files are telling you?
    How do you know process is hanging as opposed to being building indexes or validating constraints?
    Hi gopu,
    during importing, and at the middle time, trace files keep on generating upto the free size of that particular disk. i am not able to delete the trace file also, as consequence, the process hangs. then i start from the beginning, even the same continues.
    most urgent, reply is most appreciable

    thanks
    dhaya

  6. #6
    Join Date
    Apr 2008
    Posts
    8
    Quote Originally Posted by OracleDisected
    Hi,

    I've done thousands of imports for BaaN DB on 9i , and I've never seen something like that...

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

    Usually for BaaN you only need to import tables, do you have any SP developed in-house?

    Regards
    Ignacio

    http://oracledisect.blogspot.com
    Can u tried to import by giving statistics=none ?

  7. #7
    Join Date
    Apr 2008
    Posts
    9
    hi,
    i have tried by using the parameter statistics=none. while running import, large size of trace file is producing. the trace file generating upto free space in the particular disk. then import hangs. i am not able to do further.
    then i restart the service and delete the dump file and proceed from the first.

    thanks
    dhaya

  8. #8
    Join Date
    Apr 2008
    Posts
    8
    What is size of import file?
    Did you check why traces file content ?
    check also your alertlog file

  9. #9
    Join Date
    Apr 2008
    Posts
    9
    the size of the import file is 80 gb.
    there is no related content in the alert log file.
    the trace file size minimum 30 gb.

    help me out in this.

    i have small suspection in PGA utilization and the size.

    what about direct= y parameter.

    help me out in this.

    thanks
    dhaya

  10. #10
    Join Date
    Apr 2008
    Posts
    8
    Quote Originally Posted by dhayanithy

    the trace file size minimum 30 gb.

    thanks
    dhaya
    trace file size is 30 GB ? is it the total size of the dumpfile ??
    what the trace file is saying ?

  11. #11
    Join Date
    Apr 2008
    Posts
    9
    I am not able to analyse with the tkprof.

    any suggestion is appreciable.

  12. #12
    Join Date
    Apr 2008
    Posts
    8
    do like this

    tkprof filename.trace newfilename.txt

  13. #13
    Join Date
    Apr 2008
    Posts
    8
    can you post the content of the trace file ..?

  14. #14
    Join Date
    Apr 2008
    Posts
    9
    Currently import is going on with some modification in the parameters. if still problem existing means i will analyse through the tkprof and send the content to u
    keep scribbling

    thanks
    dhaya

  15. #15
    Join Date
    Apr 2008
    Posts
    8
    k dhaya
    let it continue

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •