Re: Oracle LONG RAW's and Tar's

in article 3ADC4F81.DF7E7F2A_at_m1a2r3.dfo-mpo.gc.cax, James Hanway at hanwayj_at_m1a2r3.dfo-mpo.gc.cax wrote on 18/04/2001 00:13:

> I apologize for cross posting this, but the issue hits both subjects.
>
> I'm have an Oracle 7.3.4 database on a Digital 4000 server running
> Digital Unix 4.0D. The database takes GIS files from a user's working
> directory, .tar.Z's them up and then loads/unloads them into an Oracle
> LONG RAW field via PL/SQL calls. On occasion during an extract, the tar
> command (/usr/ucb/tar) will come back and prompt "Ready for Volume 2,
> type go when ready" . These tar files do not span any volumes or drives
> - they sit as a single file on a single partition (RAID 5)..
>
> Has anyone seen such behavior from the tar command?

I hate having to be a mind reader.

    Are you uncompressing the .Z files the using tar on the resulting file? If so how big is the filesize of the tar image? Tar has had some intrinsic filesize limits. If the above is what your doing alternate to using a pipe

zcat < file.tar.Z | tar xvf -

    Cheers

        Mark ;) Received on Wed Apr 18 2001 - 20:51:05 CDT