Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: imp can't read my export file, what does this error mean?
In <91884734.0310011457.238f6b96_at_posting.google.com> joel-garry_at_home.com (Joel Garry) writes:
>Stan Brown <stanb_at_panix.com> wrote in message news:<blf3o0$m7r$2_at_reader2.panix.com>...
>> In <b7vlnv8gicmco8a8oqcs14a8o836vqajni_at_4ax.com> Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> writes:
>>
>> >On Wed, 1 Oct 2003 15:50:04 +0000 (UTC), Stan Brown <stanb_at_panix.com>
>> >wrote:
>>
>> >>What the heck is this trying to tell me?
>> >>
>> >That you still don't know what you are doing and are up for your next
>> >saga of just hacking around
>> >>Is this file too big of imp?
>> >>
>> >Yup,
>>
>> >2 Gb filelimit
>>
>> Ok, but this file was _created_ by exp from the same 7.3.4.5 instnace, and
>> looking at it, it seems to have valid data in it. So, there must be _some_
>> way of imporitng bits of it. Right?
>No. However, you might be able to use the unix strings command to get
>some data to load with sqlldr. Or if it is not actually messed up,
>try piping it to imp, perhaps the OS is trying to tell you O can't
>deal with the large file and going through a named pipe will mellow it
>out. Personally, I've had very bad luck with NFS and many G files.
>Do a tail on the file and see if it says EXIT twice or looks like it's
>in the middle of data. See metalink Note: 1023811.6 for pipe example.
Turend out piping it was the answer. Aarently imp can't deal with files
>2G, and blames it on the OS. Of course the OS is perfectly capable of
dealing with these (even over NFS), and thus it can streram the file to
imp.
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Thu Oct 02 2003 - 06:01:27 CDT