Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Unanswered: Help Me with this script

    first of all,sorry for my bad english..
    Im created one procedure call it loadutopen:

    create or replace
    PACKAGE "FDS_FIN_LOAD" as
    procedure LoadUTOpen (iFileID number);
    end FDS_FIN_LOAD;



    and im run thats procedure :exec fds_fin_load.loadutopen(5); from txt file with data need to load arround 8million record.

    After im run that procedure im got this error massage:

    ERROR at line 1:
    ORA-04030: out of process memory when trying to allocate 32792 bytes (QERHJ
    hash-joi,QERHJ Bit vector)
    ORA-06512: at "FDSDM21.ORA_PKREF", line 8
    ORA-06512: at "FDSDM21.FDS_FIN_LOAD", line 1455
    ORA-04030: out of process memory when trying to allocate 8040 bytes
    (kghds:koksHash,kokqhte*[]: kokqHashTableInit)
    ORA-06512: at line 1

    can anyone help me find out the solutions.:o:(
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2012
    Posts
    2
    Or is it im need to put or write an exception handler ??

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you are using Oracle (I see ORA-XXXX errros), then try posting your question in the Oracle forum.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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