-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|