Re: Size Limit Question from a Non-DBA

From: Jim Gregory <jim.gregory_at_daytonoh.ncr.com>
Date: 1996/12/11
Message-ID: <E29H5L.1Dx@intruder.daytonoh.ncr.com>#1/1

It's a restriction on most unix file systems. If your data within your DB is under 2G you can still export directly to a file, or if bigger than 2G, you can export to a tape instead of a disk file, or you can export to a pipe with the pipe output going to a compression utility and then to a disk file or tape. With compression, we've been able to get as much as 10G tables compressed to under 2G.

HTH
Jim Gregory

>==========John Bruni, 12/11/96==========
>
>We are currently running Oracle 7.2.2.3 on a SUN box, (Solaris 2.4).
>
>We would like to do an export of our data base but are told that
>there is a
>2GB limit on the file size. Therefore, instead of exporting the
>data base
>in it's entirety we have to break it up.
>
>Anyone experience this.
>

Opinions expressed are mine and do not reflect those of my company or clients. Received on Wed Dec 11 1996 - 00:00:00 CST