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

Quote:

---

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...

Quote:

---

ORA-21503 program terminated by fatal error

Cause: A program is in an unrecoverable error state.

Action: Report to Oracle Support Services.

---

HTH.

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