Re: Problem importing file over 2Gb...

In article <o8rsN5doqUD8Fx8u4s8rS5mpNT9g_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to "Maria Nordfeldt" <mnt98002_at_student.mdh.se>
> (if that email address didn't require changing)
> On Sat, 25 Sep 1999 13:51:59 +0200, you wrote:
>
> >Hi,
> >I have problem importing an export-file that is 20 Gb large.
> >I'm running IBM AIX 4.3 with Oracle 7.3.4.4. The file is stored
> >on a "Large Enabled Filesystem".
> >I got ORA-00021 message. "Cannot read file....".
> >
> >I can read the file with the cat-command or more-command.
> >
> >I've exported the file on a Digital Unix machine, with the same
> >Oracle release.
> >
> >Has anyone run in to this problem before....
> >
> >/Maria
> >
>
> Try using a PIPE so the device imp gets is not a 'seekable' device.
when you
> give IMP a straight file, it'll try to seek around the file but since
its >2gig
> it'll fail.
>
> try this:
>
> $ mknod -p input.dat
> $ cat the_real_input_file.dat > input.dat &
> $ imp .... file=input.dat ....
>
> since IMP is reading from a device that does not support seeking,
this will work
> (as long as cat is OK with the big file).
>
> --
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>

Maria, I think Thomas and Conner both replied with good posts, but I would like to add that it is my understanding that on some platforms Oracle 7.3 can not handle OS files greater than 2GB so you should make sure your export completed cleanly. We discovered this fact on a Sun where we took the system over from the customer and they had not been checking the export log. Fortunately I did before we needed it.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 25 1999 - 15:57:45 CDT