import error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: import error

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Post import error

    Hi all,

    I have exported a particular schema of a database(source) and trying to import the same in another database(target) which has a similar set up in the same server.

    after a certain point i get the below error.Iam using ORACLE 9.2.0.2.0.Server is AIX

    IMP-00058: ORACLE error 21503 encountered
    ORA-21503: program terminated by fatal errorkgefec: fatal error 0
    OCI-21503: program terminated by fatal error
    OCI-04030: out of process memory when trying to allocate 400 bytes (Alloc statem
    en,alloc define hndl)
    Errors in file :
    OCI-21503: program terminated by fatal error
    OCI-04030: out of process memory when trying to allocate 400 bytes (Alloc statem
    en,alloc define hndl)

    can any of you explain the reason and how to rectify?

    Cheers
    gtham

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: import error

    Originally posted by gtham_tem

    IMP-00058: ORACLE error 21503 encountered
    ORA-21503: program terminated by fatal errorkgefec: fatal error 0
    OCI-21503: program terminated by fatal error
    OCI-04030: out of process memory when trying to allocate 400 bytes (Alloc statem
    en,alloc define hndl)
    Errors in file :
    OCI-21503: program terminated by fatal error
    OCI-04030: out of process memory when trying to allocate 400 bytes (Alloc statem
    en,alloc define hndl)
    Quote from the docs...
    ORA-21503 program terminated by fatal error

    Cause: A program is in an unrecoverable error state.

    Action: Report to Oracle Support Services.
    HTH.

  3. #3
    Join Date
    Apr 2003
    Posts
    14
    I think...
    set commit=y and set RECORDLENGTH=65536
    This will cause the import to commit at certain record counts

    Try that and let me know
    Moe M Haroon

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