Re: Import /Export Errors Coredump with fatal error

Massa Batheli wrote:
> There are two large tables(88G and 44G) that need exported /imported .
> Direct exports did it but during imports oracle error IMP-00009 popped
> up .
> Metalink advice --Use a buffer to work around it and that is when all
> my issues started.
>
> : fatal error 0
> ********** Internal heap ERROR 17113 addr=0x0 *********
>
> even when there was no buffer parameter which means it was set to 4096
> because this eror could be caused by very large buffers .
> Has anyone had this error before and how did you go around it
>
> Thanks a million for your time..

IMP-00009 seems to indicate an abnormal end of the export file. What Oracle version? Did you verify that the import file was not affected by an OS size limitation (2GB, 4GB, etc.)? Did you transfer the import file from one computer to another? Is there sufficient disk space (and in the affected tablespaces) on the server where the import is being performed? Did you generate a log for the export and the import. What are the exact commands and parameters that you are using?

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Nov 13 2006 - 11:35:35 CST