Re: store zipped file in Oracle

From: Rus Rayburn <rus_at_localhost.localdomain>
Date: Sun, 16 Jan 2000 02:27:37 -0500
Message-ID: <Pine.LNX.4.10.10001160223410.1778-100000@localhost.localdomain>

Haven't seen this done before, but it seems you could store the ziped file in a table with the BLOB type. Display, however, would be a problem.

You might want to try storing the text files in VARCHAR(2) fields. VARCHAR(2) uses only enough space to hold the data, ie column set to VARCHAR(2)5000 holding a 937 character file would only use 937.

On Sun, 16 Jan 2000 vincentpang_at_hotmail.com wrote:

> I need to store a lot of text files into Oracle. As I know, there is no
> compression in Oracle. In order to reduce the DB size, I want to store
> the file in zipped/compressed format. Is it common to store the
> zipped/compressed file in Oracle (in 'Long Raw' in Ver7.3.3 or 'LOB' in
> Ver8)? Any good way to retrieve the zipped file for display?
>
> Thanks your help.
> Vincent,16Jan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
>
Received on Sun Jan 16 2000 - 01:27:37 CST